Trouble transfroming json data

[Craig-Reid]

Hi

I'm just getting started with Budibase and finding it quite intuitive. Have a problem transforming data that I receive as a response from the REST API call

The data is returned as this

{
"header": [
{
"displayName": "Project Name",
"uri": "urn:code:project-list-column:name"
},
{
"displayName": "Opp Status Code",
"uri": "urn:code-tenant:project-object-extension-column:7dd7ece8-435f-45aa-a17f-055a72879584"
}
],
"rows": [
{
"cells": [
{
"dataType": "urn:code:list-type:string",
"textValue": "Non-billable"
},
{
"dataType": "urn:code:list-type:object",
"textValue": "1.1 Prospect"
},
{
"dataType": "urn:code:list-type:string",
"textValue": "My Project"
},
{
"dataType": "urn:code:list-type:object",
"textValue": "3. Execution"
}
]
}
]
}

(I've edited the returned data - but get many entries for cells (132 in all))

My data when displayed in a table within budibase appears like this

{header} {row}
[{"displayName":"Project.... [{"cells":[{"dataType":....

I'm wanting to form and return as table like this

Project Name Opp Status Code
Non Billable 1.1 Prospect
My Project 3 Execution

I've read the JS scription suggestions for transformers, tried lots of combinations but I don't seem to get it to work. Any help appreciated.

[mikesealey]

Hey @Craig-Reid - this is often unique to each API, and so it's difficult to give specific support with.

In this instance, you'll probably want to return data.rows.

When you've made a successful query you should be able to make changes to the schema that looks like this. Once you're happy with it, you can click "Save" - these changes will take affect and . It's worth noting that each time you run the REST API query in the Data section like this, you'll need to recreate the changes.

There's some more information on this topic in the documentation.