JSON Handler - Max JSON size exceeded
Hello all.
I wonder if anybody could offer any advice on a problem i'm having please?
I have set up an 'Fetch a JSON resource' in pipelines, which is to a third party ID check. Prior to the candi...
Forum Discussion
Hi Chayce.
Thank you again for your time to look at this, I really appreciate it.
Unfortunately, I have only been provided with one scope code :(, so I don't think there is anything I could do with that. Do you think there is any way in which I could limit/customise the payload by entering anything in the request body?
As regards the 'Make Request' channel, I have tried this already. For smaller payloads I am unable to work out how to get the data I want (i've tried multiple formats). Here is an example of what is returned:
If I use {{b.json}} it populates the field in QB with this (example)
[{"id":"ef72561a-2b96-45d0-a3c2-8743f0819612","data":{"pseudonym":"ANON-bf210fcd-49ff-4dac-9264-5d7522f212bf","product_name":"eID Substantial (anoniem)","status":"pending","purchase_start_date":"2023-09-08T08:08:02Z","purchase_completed_date":null}}]
If i try to amend to {{b.json.data}} or {{b.json.status}} or {{b.json_data}} or {{b.json_data.status}} I don't get any data returned in the field.
What would I need to just ectract the 'status' to populate a QB field please?
As regards size, it would appear that there is a size restriction on webhook, although I don't know what it is. If I try and GET a completed ID check I get an error message saying the object has exceeded the maximum limit.
I do have the option to GET a pdf report (metadata report) by using the same link and credentials but replacing .json? in the url to .pdf? However, If I try this using webhook 'Make Request' it returns the following:
Is there any other channel I could use to GET the pdf report? I would need to include a header with the Authroization token.
Thank you,
Michael
------------------------------
Michael White
------------------------------
Michael,
This might be of use to you when you are trying to get a value from the response:
To capture an XML response from an API in Pipelines | Discussions (quickbase.com)
maybe {{ b.json["status"] }}?
------------------------------
Tim D
------------------------------
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
------------------------------Thank you Tim :)
I will take a look at that link and let you know how I get on.
Thanks,
Michael
------------------------------
Michael White
------------------------------
