.png&w=3840&q=75){kind=logo}
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"?
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::LBKS{"email":: "sam@clay.com", "name": "Sam"} Sources: HTTP API - Clay University HTTP API with Clay
talk to person
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
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
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
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
I think there is a bug unless I'm being dumb
Recording loom gimme 2
Almost sure there's a bug
- Bo (.··
Yup - It looks like we've got a bug on our hands - I've escalated this over to our engineering team and we'll let you know as soon as we know more! In the meantime, https://cln.sh/V7Zd9YmQ That should help you get around this
Sounds good -- thanks Bo
Bo, quick q -- is it possible to use a formula instead of selecting from the drop down when choosing the "waterfall output" for a pre-built enrichment (i.e. RocketReach Enrich Person). This API call returns a list of emails, and I want to use a custom formula to return the first email where grade === "A" | "B"
- Bo (.··
Let me help you with this! While we can't use a formula directly in the waterfall output for pre-built enrichments right now, I've got a solid workaround using a Merge Column instead: 1. Run your RocketReach enrichment first 2. Set up a backup enrichment as your fallback 3. Add a Merge Column where you can use your custom formula to pull those A/B grade emails 4. If needed, add one more enrichment with a conditional formula that runs only if step 3 comes up empty Let me know if you need more help https://downloads.intercomcdn.com/i/o/w28k1kwz/1263395163/21aabeb47259ca986feb7efae4fa/CleanShot+2024-11-23+at+_38kQOUABSt%402x.png?expires=1732394700&signature=73a9a97eb18c0381c67001c9c511b98b6114116182891c485358733ead63a4d2&req=dSIhFcp3mIBZWvMW1HO4zbTCy9i7DSvq1EVRGNySyiXiN1o%2FmhBdV8y4wy9L%0AnuTe%0A
I was playing around and looks like you actually CAN use a custom formula here If you select an list value from the pre-defined JSON output, it will change the input column from a dropdown to a formula where you can enter a custom formula
- Bo (.··
Sorry would you mind showing me how? I'm not able on my end ? https://downloads.intercomcdn.com/i/o/w28k1kwz/1263418810/515a1b9b4bf6f91f08deb35781ed/CleanShot+2024-11-23+at+_19Oo8atuqZ.gif?expires=1732397400&signature=2d412671735ae2ad4fa7e5d74ba7473b331cde9ec081427791a44997c413d003&req=dSIhFc1%2FlYleWfMW1HO4zYH6stMdYJp%2Bomxl%2BGxlwnbCMvBFAq%2BEsBBuXVkh%0ASIRX%0A
Also Bo, something just happened where all my credits just got drained at once. Can you help me figure out what happened? I've reviewed the audits of all my major tables and can't figure it out. This was of course unintentional
- Bo (.··
I can't see for the next 1h-2h, but how many credits were used? Typically, that would be because a column ran in a table that was on auto-update after its dependency was updated. Here are some guides that can help: How to manage stale data Tips for saving credits Credits 101
I lost 350 credits -- it may or may not be related to a glitch where the "email validation" in my custom waterfall automatically reverts to zerobounce, even after I changed it to my own NeverBounce account. I.e. these columns shouldn't have gotten created.
Is there a way to check my "credit usage" without having to check each individual column?
- Bo (.··
No, you would need to use the individual column check. No worries though, I added the credits here and I've noted it that we refunded you for this! :)
Thank you so much -- truly appreciated. I will try to figure out what happened
Also running into another small bug (just tell me when you want me to stop! lol) In the company domain column, there are blank cells, that are not being recognized as blank in either the filters or sorts. I also created a formula to check if the cells were blank, and even that returns "true" for blank cells Not sure what's happening -- my guess is there were hidden characters in the csv I uploaded but not sure https://app.clay.com/workspaces/423342/workbooks/wb_2yzrNp8cphiU/tables/t_kU5fhheSwgqo/views/gv_D7dgfw3jwKAE
- Bo (.··
Which rows for example?
Look at row 304
in the Restaurant Contacts sheet
You can see the formula is still returning true even when it's blank
Hey Mathew! Thanks for the message. We've escalated this to the team to troubleshoot and will get back as soon as we have an update. Apologies for the inconvenience.
FYI -- this is being caused by hidden chars -- any idea how to fix this?
Hey there Mathew, jumping in for Daniela here, let me reach out to the team and see if anyone knows how to address this.
Sounds good. I ran a formula column that returned the "length" of the "empty" cell. It returned 1 for the cells with hidden chars. It's a fine workaround for now. Would be nice is there was a way to clean the CSV while uploading
- Bo (.··
Hey! 👋 Awesome news - our engineers found and fixed the issue! Turns out there was a sneaky U+2060 unicode "word-joiner" character hiding in that empty string. We've removed it and everything should be working smoothly now. I'll close this ticket since it's resolved, but feel free to give it a try and let me know if you run into any other quirks! 😊
Fantastic -- thank you!