Extract json from 'data' table

Describe the problem/error/question

When calling an API, the API returns the expected JSON but in a data table. How do I extract the json from the table?

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 0.233.1
  • Database (default: SQLite): MySQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Linux
1 Like

Hi @sentry

Since you’re getting the data as a plaintext. Here is how you can use JSON parse to make it as actual json.

Excellent, this worked - thanks!

1 Like

You’re welcome. :heart:

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.