Is there a way to easily parse JSON responses from HTTP API calls within Clay? Similar to “normalize XYZ”? Struggling to find something that’s already natively available.
Yes, when using the HTTP API integration, you can easily parse specific data from JSON responses using the "Field Paths to Return" option. This feature allows you to:• Specify exactly which fields you want to extract from the API response• Use dot notation for nested parameters (e.g., object1.object2.name)• Filter out unnecessary data from responses with large amounts of information• Enter multiple field paths, separated by commasThis is particularly useful when working with APIs that return unpredictable or extensive data sets, helping you focus on just the information you need. Sources: HTTP API with Clay HTTP API - Clay University HTTP API with JWT Authentication - Clay University
What if one of my fields contains a JSON schema itself? I would like to parse the contents of one of the fields
When working with JSON responses in HTTP API calls, you can use the "Field Paths to Return" option to extract specific data from nested JSON structures. For nested parameters, use dot path notation (e.g., object1.object2.name) to access deeper levels of the JSON structure.You can enter multiple field paths by separating them with commas. This feature is particularly useful when dealing with APIs that return large amounts of data and you only need specific fields.To ensure proper parsing:1. Make sure your JSON is properly formatted 2. Use quotes for strings 3. Don't use quotes for numbers and booleans 4. Use proper dot notation for nested fields Sources: HTTP API - Clay University HTTP API with JWT Authentication - Clay University HTTP API with JWT Authentication with Clay
I am trying to parse a nested field……..
You can use dot path notation to access nested fields within a JSON response. In the "Field Paths to Return" section, specify the path to your desired data using dots to separate nested levels (e.g., object1.object2.name).This feature is particularly useful when working with APIs that return large amounts of data but you only need specific fields. By defining the exact paths you want to retrieve, you can filter out unnecessary data from the response.For multiple fields, simply separate each path with a comma. Sources: HTTP API with JWT Authentication with Clay HTTP API - Clay University
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!
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=1733445000&signature=8e2239cc36402acdfed5dddaa42d425c815a34e18e72de6b3111b78dd2076e3b&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSj4ApIW2BKsam%2FhVPuXJA%3D%3D%0A
Under the first HTTP API > Choices > Message > Content
I see - What do you want to parse them for? In this table? In another table? What's your end goal here ultimately?
Parse them into this table into separate columns ideally
Here's a video that's explaning how: https://cln.sh/4frvgBzJ More on formulas: https://www.clay.com/university/lesson/how-to-use-ai-formulas
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!