You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
And this returns as a table, of course, with "object" as a JSON string. However that's actually really awkward when trying to process it in Javascript (Using the excellent Business Text Panel) given that as it's a table, it then also comes with a schema and I then need to look up the array index for the right column name etc.
I'm sure it's a doddle, but what would be the JSONata to wrap the response in another object so I can just get the entire original JSON as a single string field and then parse it directly to a Javascript object myself? On a test JSONata site, "[$]" puts the whole body into a single element array, but not in Infinity.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I've an API which returns an array of objects:
And this returns as a table, of course, with "object" as a JSON string. However that's actually really awkward when trying to process it in Javascript (Using the excellent Business Text Panel) given that as it's a table, it then also comes with a schema and I then need to look up the array index for the right column name etc.
I'm sure it's a doddle, but what would be the JSONata to wrap the response in another object so I can just get the entire original JSON as a single string field and then parse it directly to a Javascript object myself? On a test JSONata site, "[$]" puts the whole body into a single element array, but not in Infinity.
Is JSONata the solution? Is there another?
Beta Was this translation helpful? Give feedback.
All reactions