Home

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

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

How to Map Last API Call Result to Another Column in Excel | Clay

How to Map Last API Call Result to Another Column in Excel

·Aug 04, 2025 05:51 PM·

I have various API calls, each potentially returning hundreds of outputs. I want to pull the last result from each call into another column. The challenge is that the number of results varies — some calls might have 230 outputs, others only 20. How can I always map the last result to another column?

Loading attachments

4 comments

· Sorted by Oldest

Clay
APP
·
·
To extract the last result from API calls with varying output lengths, click on a cell containing your API results to open the Cell details panel. Hover over the specific endpoint you want (the last item in your array) and click "Add as column" to create a new column with that data. You can also reference individual list items by drilling down to extract specific items within a list and access their properties, allowing you to target the last result regardless of array length.
Sources: Table columns | Documentation | Clay University Referencing dynamic data from other columns | Documentation | Clay University
Muhammad S.
·
·
to get hold of the last item in array you can slice the array in this form array[-1], you can get this done via formula
Clay
APP
·
·
Exactly! You can use AI formulas to slice arrays and get the last item with array[-1] syntax. Add a new formula column, then prompt our AI to extract the last item from your API results array using this slicing method. AI formulas are credit-free and perfect for data formatting tasks like this.
Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Sayli G.
·
·
Hello João! Thanks for reaching out! You can trying using AI formulas to try and get the last item in your field!