I’m receiving up to 20 results like this from an API call. What’s the best way to get each result into a new table as it’s own row? i.e. have the domain https://www.homeinstead.com/location/289? as the unique identifier, add a few more of the respective properties in other columns and do that for all of the results. Thanks!
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Hi Andreas! Happy to help! Just to clarify, you want to write the 20 businesses with associated data points into a new table? The way to do this is to right click on "Places" and click "Write each item to new row in other table" (see image) Let me know if this is what you're looking for! If not, I jump in again :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1223207185/b84c1f39c6540c5570a2042f0b06/Arc_SgKkqCfqdQ.png?expires=1729518300&signature=8818bb05160b7681306b3699fb9109bc9442e5383105b31da69f92a378f164ed&req=dSIlFct%2BmoBXXPMW1HO4zb%2ByAEDyt1CXE4xMLE1rIV%2BueP%2FCXwKQxulWKbJO%0AZpjt%0A
beautiful! That will be it. But getting an error so far…
Hey Andreas! 🌟 To address the column mapping concern, for now, you'll need to manually map the columns as shown in the image below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1223276413/4e51cc3f7c2f782a4f12efab01f4/Berrycast_lPAWrTnbVl.png?expires=1729521000&signature=ad46e69cdb93c1a11967910369567b41da8c6a4de3eb913e09685b9b7685a021&req=dSIlFct5m4VeWvMW1HO4zfqQpfA5zwzHsT%2BGomHt%2F9kFES690fv8cI4PtRoh%0AHhCj%0A But, good news! A release is on the way that will allow you to skip this mapping step. You'll be able to transfer all columns to the new table with just one click! 🤞 Let's hope it arrives soon! Hope this helps! 🚀
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!
Hi Andreas W.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: