ContributionsMost RecentMost LikesSolutionsRe: Opposing Checkboxes Hi Steve. I don't know if this helps but I used a Forumla button to do this. If one checkbox is set to '1' then the others are set to '0'. If ([IOE Authorisation Revoked]=false and [IOE Authorised]=true, URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=cf5y3a7djhknc9z2kgrab8kjtp8" & "&_fid_263=1" & "&_fid_259=0" & "&_fid_275=0" & "&_fid_267=0" & "&_fid_271=0" & "&_fid_100=" & Now() & "&_fid_102="& URLEncode(User()) & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])) Fields 263, 259, 275, 267 and 271 are all checkboxes. The code above removes the tick from 259,275,267 and 271 when a tick is placed in 263. I hope this helps. Michael ------------------------------ Michael White ------------------------------ Re: JSON Handler - Max JSON size exceeded Thank you Tim :) I will take a look at that link and let you know how I get on. Thanks, Michael ------------------------------ Michael White ------------------------------ Re: JSON Handler - Max JSON size exceeded 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 ------------------------------ Re: JSON Handler - Max JSON size exceeded 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 ------------------------------ Re: JSON Handler - Max JSON size exceeded Hi Chayce. The third party is Digidentity. The documentation can be found here: https://docs.digidentity.com/#aae3b6c2-c2b0-4250-9335-9a402eaf3dbd It's under 'Onboarding', 'One-time verification', 'Retrieve report'. Thank you, Michael ------------------------------ Michael White ------------------------------ Re: JSON Handler - Max JSON size exceeded Hi Chanyce. Thank you for the reply. I have been trying to limit the payload, but i'll be honest I've no idea how to do that. You can see from below the size of each 'item'. I don't actually need the four large images which are causing the issue, but i've no idea how i can call the payload just for the other items. Here is how i've set all the fields in the JSON handler 'fetch' request. Have you got any ideas please? Many thanks, Michael ------------------------------ Michael White ------------------------------ 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 candidate completing the ID check I can fetch the JSON data and import it into QB through Pipelines. However, once the candidate completes the ID check the JSON contains considerably more fields and when I try to 'Fetch a JSON resource' I get a validation error. Validation error: Maximum JSON size exceeded Is there any way in which I can overcome this please? Here is an example of what is in the JSON. [ { "id": "e4x69a61-07mp-46le-aj80-0c52f12a673e", "data": { "pseudonym": "ANON-e2x0a6mp-37l0-42ps-94ef-u69755438d3o", "product_name": "Test Product", "status": "completed", "purchase_start_date": "2022-03-16T09:33:52Z", "purchase_completed_date": "2022-03-16T09:33:52Z", "date_of_birth": "1974-01-17", "first_name": "JOHN", "gender": "-", "surname": "DOE", "liveness_verified_selfie_1": [ "iVBORw0KGgoAAAANSUhEUgAAAJYAA...MTkrMDA6MDDuShMbAAAAAElFTkSuQmCC\n"], "liveness_verified_selfie_2": [ "iVBORw0KGgoAAAANSUhEUgAAAJYAA...R24Ac1JHQrqQcwcAAAAASUVORK5CYII=\n"], "driving_licence_hd_attachment": null, "id_card_hd_attachment": null, "passport_hd_attachment": [ "iVBORw0KGgoAAAANSUhEUgAAAJYAA...MTkrMDA6MDDuShMbAAAAAElFTkSuQmCC\n", "iVBORw0KGgoAAAANSUhEUgAAAJYAA...R24Ac1JHQrqQcwcAAAAASUVORK5CYII=\n"], "age": 49, "age_is_18_plus": true, "driving_licence_attachment": null, "driving_licence_expiration_date": null, "driving_licence_number": null, "driving_licence_state": null, "driving_licence_verified_at": null, "full_name": "GARY GIRAFFE", "id_card_attachment": null, "id_card_expiration_date": null, "id_card_number": null, "id_card_state": null, "id_card_verified_at": null, "liveness_verified_selfie_1_at": "2023-04-11T11:17:03.386Z", "liveness_verified_selfie_2_at": "2023-04-11T11:17:03.386Z", "middle_name": null, "passport_attachment": [ "iVBORw0KGgoAAAANSUhEUgAAAJYAA...MTkrMDA6MDDuShMbAAAAAElFTkSuQmCC\n", "iVBORw0KGgoAAAANSUhEUgAAAJYAA...R24Ac1JHQrqQcwcAAAAASUVORK5CYII=\n"], "passport_expiration_date": "2028-07-09", "passport_number": "1234567890", "passport_state": "accepted", "passport_verified_at": "2022-01-20T09:10:25.154Z" } } ] Thank you, Michael ------------------------------ Michael White ------------------------------ Re: Pipeline Webhook Help Please Hi Katlyn. You are an absolute star, thank you 😊. That worked first time and i'm now smiling again 😊 Thank you, Michael ------------------------------ Michael White ------------------------------ Re: Authorization using Bearer Token (Pipeline Webhook) Hi Chayce. Thank you for the reply. Yes, it is Oauth2, which I think is adding to the problem. Something tells me I'm not going to be able to get this to work 😌 Thank you anyway. Michael ------------------------------ Michael White ------------------------------ Re: Pipeline Webhook Help Please Thank you for the suggestion Brian. I have already tried to add it to the headers, but it makes no difference 😌 Thank you anyway. I'm coming to the conclusion that the webhook functionality in Quickbase isn't sufficient for this API. My other option is to see if I can use a webhook and go via Postman, but i'm not sure if that is possible. Thanks, Michael ------------------------------ Michael White ------------------------------