Troubleshooting API Call Datasets for Formula Column Output

Joseph L. · 2025-06-12 02:05:41.08648+00

One of API calls spits out multiple datasets (see screen1) and I'm trying to output one of those datasets into a formula column but it's not presenting the options (screen2). It's called A-Leads. As you can see it worked for another API call called Reoon which shows 19 different datasets, not sure why this one isn't working. I don't want to have to create unnecessary columns in my table for each and every dataset I want to pull from this API call.

Troubleshooting API Call Datasets for Formula Column Output | Clay

9 comments

· Sorted by Oldest

Channeled
APP
·
·
This issue might be related to how the API response data is structured or parsed. To troubleshoot: 1. Check if there are any parsing errors in the API response body 2. Ensure proper syntax in your formula (quotes, commas, brackets) 3. Try defining specific field paths to return in your API settings 4. Check for hidden characters that might be causing issues Could you share the JSON response or formula you're using? This would help me diagnose the specific problem.
Sources: HTTP API integration overview | Documentation | Clay University HTTP API integration overview | Documentation | Clay University HTTP API with JWT authentication | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Joseph L.
·
·
Anybody?
Khush I.
·
·
Hey Doug, There should be an option to either add the output from the HTTP API as a new column in your table or map it to an existing one. Once the data is available in a column, you can easily reference it in a formula column (see Image 1). I understand your concern about keeping the table clean, if you'd prefer not to display the extra column, you can always hide it (see Image 2). Adding the data to a column and referencing it through a formula also helps maintain provenance, making the table more robust and transparent. If this behavior feels limiting or unexpected, feel free to report it in the #bugs channel so the team can take a closer look.
Joseph L.
·
·
Hi Khush I. I know this can be fixed by adding additional columns and pulling those into the formulas, but why does it let me pull outputs from Reoon (another API enrichment) without creating columns, while A-Leads doesn't?
Joseph L.
·
·
Khush I.
Joseph L.
·
·
I created a brand new column and it says "column removed"? https://vento.so/view/5b116706-8408-4d96-a0a3-0983379fe87e?utm_medium=share
Channeled
APP
·
·
Hello Doug! Thanks for reaching out! Can you send me your table link URL to look into it further!
(52 kB)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Joseph L.
·
·
See job poster table: https://app.clay.com/workspaces/591769/workbooks/wb_0svyoklu4aBkok3hvyM/tables/t_0svyokpDbPk3tyTGxu7/views/gv_N7AQ5nu2VCHp

Loading comments

Channeled
APP
·
·
This issue might be related to how the API response data is structured or parsed. To troubleshoot: 1. Check if there are any parsing errors in the API response body 2. Ensure proper syntax in your formula (quotes, commas, brackets) 3. Try defining specific field paths to return in your API settings 4. Check for hidden characters that might be causing issues Could you share the JSON response or formula you're using? This would help me diagnose the specific problem.
Sources: HTTP API integration overview | Documentation | Clay University HTTP API integration overview | Documentation | Clay University HTTP API with JWT authentication | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Joseph L.
·
·
Anybody?
Khush I.
·
·
Hey Doug, There should be an option to either add the output from the HTTP API as a new column in your table or map it to an existing one. Once the data is available in a column, you can easily reference it in a formula column (see Image 1). I understand your concern about keeping the table clean, if you'd prefer not to display the extra column, you can always hide it (see Image 2). Adding the data to a column and referencing it through a formula also helps maintain provenance, making the table more robust and transparent. If this behavior feels limiting or unexpected, feel free to report it in the #bugs channel so the team can take a closer look.
Joseph L.
·
·
Hi Khush I. I know this can be fixed by adding additional columns and pulling those into the formulas, but why does it let me pull outputs from Reoon (another API enrichment) without creating columns, while A-Leads doesn't?
Joseph L.
·
·
Khush I.
Joseph L.
·
·
I created a brand new column and it says "column removed"? https://vento.so/view/5b116706-8408-4d96-a0a3-0983379fe87e?utm_medium=share
Channeled
APP
·
·
Hello Doug! Thanks for reaching out! Can you send me your table link URL to look into it further!
(52 kB)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Joseph L.
·
·
See job poster table: https://app.clay.com/workspaces/591769/workbooks/wb_0svyoklu4aBkok3hvyM/tables/t_0svyokpDbPk3tyTGxu7/views/gv_N7AQ5nu2VCHp