Financial API JSON to CSV: Flatten It Without Code

Financial APIs return nested JSON. A CSV is the simplest file to load into a database, a script or a spreadsheet.

Open the API Response to Table

Paste the JSON or call the API with API Response to Table, then download CSV. Nested objects become columns named by their path, such as company.sector, and a list of records becomes the rows. If the response holds more than one list, choose the one you need.

Finance data has a few traps. Keep tickers, ISINs and account ids as text, so leading zeros and long numbers are not changed. Check that amounts arrive as numbers with the decimals you expect, and that dates are in one format. Values that are empty in the API stay empty in the file, so count them with the Data Profiler before you load the file.

CSV is plain text, so it is easy to diff, load with COPY into a database, or open in any tool. It does not store types, so the importing tool must read dates and numbers itself. If you need typed columns or a smaller file, export Parquet from the same screen.

Only GET requests over https work, and an API that blocks browser calls is refused. Use a read-only key. Nothing is uploaded to Data Utility.

Open the API Response to Table

Related tool pages

  • JSON API Response to CSV: Turn the JSON from an API into a CSV file. Nested fields become columns and you pick which list to use. Free, in your browser, with an optional token.

How to use the API Response to Table: step by step

  1. Open API Response to Table.
  2. Send the request or paste the JSON.
  3. Check the columns and pick the right list.
  4. Download CSV and profile it for blanks.

When to use the API Response to Table

  • Load API data into a database
  • Hand a flat file to an analyst
  • Check what an endpoint returns
  • Keep a dated snapshot of a response

Example

Input: GET https://api.example.com/users + Bearer token

Output: id,name,address.city 1,Ada,London

Frequently asked questions

How does the token work?

Choose Bearer token, API key in a header, or username and password, and paste the value. It is sent only to the API you call, kept in memory, and never saved or written to Data Lineage.

What if the API blocks the request?

Some APIs do not allow calls from other websites (CORS), so the browser blocks the request. Use an API that allows browser access, or ask its owner to enable CORS.

What happens to nested fields?

Nested objects are flattened into columns such as address.city. If the response has several lists, you can choose which one becomes the table.

Is it safe to use a token in API Response to Table?

Your token goes only to the API you call, straight from your browser. Data Utility never receives it or the response. It is kept in memory for that request, not saved, and not written to Data Lineage. Use a token with read-only access when you can.

Tip: Keep ids and tickers as text so leading zeros stay.