Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

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

·

·

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

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

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
·
·
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 Godse
·
·
Hello João! Thanks for reaching out! You can trying using AI formulas to try and get the last item in your field!