- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 20, 2022 02:33 PM
Happy Sunday, everyone :slightly_smiling_face: Apologies in advance for not knowing all the correct terms when referring to objects, arrays, items etc.
I was hoping someone might have either some direct support or links to relevant resources for how to extract specific pieces of data from within an array that is returned via the Data Fetcher app in Airtable. Data Fetcher has the ability to write formulas to transform fields before bringing into airtable.
Here is a screenshot of the response received from the API on the field I’d like to extract from:
And, a screenshot “zoomed out” up a level to show the overall structure of the response:
The way this currently comes into Airtable is a field for each item of the object. For some downflow work I’m doing with Webflow this format isn’t practical and I need pieces of the data to come in as one field (and thus a multi select)
What I’d like to do is extract the “tagName” field(s) from each object (i.e., product) returned and place in a field of its own across all items of the Tags field shown in the screenshot. This would then be a new array, comma-separate list, or otherwise, that I can bring in as a field called “TagName” and would then be multi-select.
Through googling around I think I want to do something along the lines of this link:
But, I’m (A) Not sure if that’s accurate and (B) Unsure how I would implement as Data Fetcher formula.
Data Fetcher does provide a comprehensive list of functions available:
https://formula.github.io/formula/docs/code/src/functions
Would love any sort of help anyone can provide to “focus” me on a path forward and can edify me for the future as well.
Thanks,
Justin