Forum Discussion
Its hard to be 100% confident if that truly is the JSON format or just Pipelines displaying it but your JSON looks like:
json: [
{
data: {},
id: "",
}
]
So going from your screenshot and the assumption that the above is the right response format you'll have to get Status by using {{b.json[0]["data"]["status"] }}. You JSON response is an array so you'll need to target the 0 index to get the actual object you're targeting and then you can grab the value of status from the data object.
As for the problems you're citing with the payload and the PDF still being too large, the only two channels that can make a generic API call are the webhook and JSON channels. Are these the only two calls that have the data you need related to the process you're building? Is there something where you could query a user profile and backdoor your way into a smaller API response that gets you what you need regardless?
------------------------------
Chayce Duncan
------------------------------
Hi Chayce.
Thank you again for the response, I will give this a go later and see what happens. I will also look to see if there are any other API calls I could possibly use as a 'back door'.
This is what the actual RAW data looks like. I've copied this from Postman (which works), although i've only copied the first few lines as the full payload, when pasted into MS Word is nearly 1800 pages long :(
[{"id":"000a7a8c-15d5-4a89-b600-d2537f4c4d55","data":{"pseudonym":"ANON-a9c36292-1232-40ea-85df-19322aff4137","product_name":"eID Substantial (anoniem)","status":"completed","purchase_start_date":"2023-09-08T11:38:46Z","purchase_completed_date":"2023-09-11T10:42:25Z","age":49,"age_is_18_plus":true,"date_of_birth":"1973-11-03","driving_licence_attachment":["iVBORw0KGgoAAAANSUhEUgAAAOEAAAEsCAIAAAC60EPzAAAAIGNIUk0AAHom\
Thanks,
Michael
------------------------------
Michael White
------------------------------