JSON Outputs

When you export from a table in JSON format what gets spat into the JSON file doesn’t really look like a nice JSON file.

Here is a table output.

What I would like to have here are the field names:

For example instead of field_25 it says “company name” which is the name of the field.

Does this all come together when the data is requested through the API instead of as table exports?

Cheers.

Hi @GSH,

If you query via API, you will still get a similar result.
You would need to run some code that makes an API call to fetch the JSON data from that grid, replace all the field keys with their table field names, and then download it.
Happy to write something up if you’d like to DM me?

Thanks Stephen. I managed to get a local javascript to do the work for me which is fine for the time being.

1 Like