Getting child attributes in JSON format to output through PUT request
I receive information via a form on Squarespace which then finds a contact in Wealthbox CRM (based data from that form), and through a webhook PUT request step, I am able to update single item fields (first name, email, etc.) within Wealthbox. HOWEVER, I cannot figure out how to enter the payload data in order to get items like an address with child attributes to update. Since there may be a primary, mailing address, or business, I don’t know what I need to do differently to pick which one to update.
Here is a screenshot showing what the output fields are with the current sample data after testing (NOTE: the fields are already populated, but in my testing, the street_line_1 should read as Sample Address Line 1):
And the information I enter (the payload field information is street_addressesa1]rstreet_line_1]):
I need some guidance on how to format the payload on the request. I even tried the custom formatting and used the AI chatbot helper and it still wouldn’t push through.
I can’t seem to find anything wrong and have tried a ton of different formats with no luck.
Thank you!
Page 1 / 1
Hi @technomnky
You may need to use this Zap action: Webhook - Custom Request (PUT)
That allows you to configure the JSON structure.
Also, look at the Response Body in the API endpoint documentation you provided.
{ "street_addresses": : { "street_line_1": "155 12th Ave.", "street_line_2": "Apt 3B", "city": "New York", "state": "New York", "zip_code": "10001", "country": "United States", "principal": true, "kind": "Work", "id": 1, "address": "155 12th Ave., Apt 3B, New York, New York 10001, United States" } ] }
Thanks for the response @Troy Tessalone, but I’ve already tried the custom PUT without any luck too. I can update the non-nested/child fields like name, birthdate, etc., but for some reason these nested ones just aren’t taking any updates - I imagine it has to be somehow related to the “ID” of the nested attribute. In Zapier I’ve tried doing it with just “1” as well as with the full ID listed and different structures but now I’ve gotten beyond my capabilities and run out of ideas...
@technomnky
For us to have more info, post these screenshots:
how your Zap step is configured in EDIT mode so we can see all the fields
any encountered errors
Thanks for keeping it going, Troy. Screenshot below. No errors are encountered when tested. I think I’ve tried all variations of using unflatten or data pass through too. I have also tried changing the “id”: to 0 or 1 as well.
@technomnky
The screenshots does not show the following which can impact the API request:
Method
URL
Headers
Sorry, I left those off as I thought I had already confirmed separately.
Method is PUT.
URL is https://api.crmworkspace.com/v1/contacts/ >I removed the client ID number for privacy purposes, but this is different than the address id listed later] - but I know the URL works as I am able to write the single line data (name, dates, etc) in the webhook PUT code with it.
Header is: ACCESS_TOKEN and then the code, which again I’m leaving out for privacy purposes. But as with the URL, it works. But if there is an additional header I need for something like this, I’m open to that (hadn’t thought that might be needed?).
@technomnky
Best to provide screenshots that show how the Zap step is actually configured.
{ "street_addresses": { "street_line_1": "155 12th Ave.", "street_line_2": "Apt 3B", "city": "New York", "state": "New York", "zip_code": "10001", "country": "United States", "principal": true, "kind": "Work", "id": 1, "address": "155 12th Ave., Apt 3B, New York, New York 10001, United States" } ] }
I updated it with the proper formatting and still no change. Tried with the phone number update too and see no changes. I see nothing that says I need to unflatten it or have data pass through as true and I’m scouring the help doc but see nothing else.
Any luck figuring this out @technomnky ? I’m oddly trying to solve the same thing.
Negative, still just a black hole of time wasted so far trying to get it! If you figure it out, I’d be thrilled to hear what it is.
@technomnky and @rmannenbw
If you are considering hiring help, there is a directory of Certified Zapier Experts: https://zapier.com/experts
Lauren H. with Zapier support came through with the solution - the problem was we need to add a content-type header.
@technomnky This is exactly how I’m sending mine via custom request and it’s working now.
Hot dawg, it worked! Thanks for keeping me updated! What a relief...
Sorry, I left those off as I thought I had already confirmed separately.
Method is PUT.
URL is alight motion sample projects >I removed the client ID number for privacy purposes, but this is different than the address id listed later] - but I know the URL works as I am able to write the single line data (name, dates, etc) in the webhook PUT code with it.
Header is: ACCESS_TOKEN and then the code, which again I’m leaving out for privacy purposes. But as with the URL, it works. But if there is an additional header I need for something like this, I’m open to that (hadn’t thought that might be needed?).