Home
Events
Groups
Members

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

University
Clay live events

Powered by Tightknit

How to Map JSON Payload Path in a Custom Waterfall with HTTP Request | Clay

How to Map JSON Payload Path in a Custom Waterfall with HTTP Request

·

·

When building a custom waterfall with an HTTP request, how do you "provide the path from the JSONs payload to be used in the waterfall"?

Loading attachments

42 comments

· Sorted by Oldest

Channeled
APP
·
·
When specifying a JSON payload in an HTTP request, you'll need to follow these guidelines: 1. Enter your JSON data in the "Body" field of the HTTP request. 2. Follow proper JSON formatting rules: • Use quotes for strings (e.g., "name": "Sam") • Don't use quotes for numbers or booleans • For dynamic variables using /column, maintain proper JSON formatting • Ensure string variables are enclosed in quotation marks • Numbers don't need quotes unless they have trailing zerosFor example, a properly formatted JSON body might look like: {"email": "sam@clay.com", "name": "Sam"} Sources: HTTP API - Clay University HTTP API with Clay
Mathew I.
·
·
talk to person
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bo (.
·
·
Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732390200&signature=af3003cc9d1ef3f4b2e2c808e1a915db8bb1f7f39d52abf294c50fff83525429&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn%2FD5cU2BKsam%2FhVPvjgQ%3D%3D%0A
Mathew I.
·
·
https://app.clay.com/workspaces/423342/workbooks/wb_2yzrNp8cphiU/tables/t_wMtWiR8shu5o/views/gv_UgM4UhAhbb2Y
Mathew I.
·
·
Working on "Custom Waterfall" column. The first step in the custom waterfall is a custom HTTP request -- so the "waterfall output" dropdown requires a custom formula. You can see what the JSON return payload looks like in "Apollo People Enrichment" column / row 1
Bo (.
·
·
Got it - Thank you for this, here's how: https://www.loom.com/share/5b364328a4234dd5b271c82eb70c0350
👍1
Mathew I.
·
·
Thanks Bo -- can you help me figure out why this isn't working? I have "person.email" as the return path, but it still seems to be showing up blank Even though you can see person.email is not blank in the actual request
Loading attachments
Mathew I.
·
·
I've tried capitalized "Person" and "Email" as well with no luck
Bo (.
·
·
But which endpoint are you calling? Right now you're posting to the domain of the company so it's being returned empty https://downloads.intercomcdn.com/i/o/w28k1kwz/1263361609/3f47b63e3750b9280d74a022c554/CleanShot+2024-11-23+at+_1663FcgmWU%402x.png?expires=1732390200&signature=1f0848210abfb86bba1d8c39272a343c572320c3bd73551b8f52c41198fd1a3a&req=dSIhFcp4nIdfUPMW1HO4zX%2BRd6VhBmXKoJLPsYqMOZtpkd1IEIzj2Fk8hhJw%0A7UH%2F%0A
Bo (.
·
·
The HTTP you're referring to, is calling to this as well: https://downloads.intercomcdn.com/i/o/w28k1kwz/1263362708/65f764dba2a91936f0cc937ed1e9/CleanShot+2024-11-23+at+_19eHCM09IR%402x.png?expires=1732391100&signature=ecebb8717d9018913389426e9e85b44ed859cfb79ade2381fdfb848ed62a818b&req=dSIhFcp4n4ZfUfMW1HO4ze0NA4oqq8gBV6H47uO6J7LmvgMUPlvyRDKRfU2v%0AKSJR%0A
Mathew I.
·
·
I think there is a bug unless I'm being dumb
Mathew I.
·
·
Recording loom gimme 2
Mathew I.
·
·
See video here: https://www.loom.com/share/f3ee804891b843d1b4c6018844633ec3?sid=6094f8ee-1d84-49b8-b3a4-349103a0dfbd
Mathew I.
·
·
Almost sure there's a bug