Turn API response into table records

I am calling a SEMrush (SEO service) api that returns a simple response with semi-colon delimited records, as below:

Rank;Organic Keywords;Organic Traffic;Organic Cost;Adwords Keywords;Adwords Traffic;Adwords Cost;Date 30;45563077;119700673;77273992;43581;1863112;1154716;20220515 29;43186576;122615505;62449837;32620;565265;463254;20220415 29;41548607;125042499;57574732;21491;300652;209224;20220315
etc…

How would I parse these and create records in a table with the same fields?

Any help appreciated.
Paul

Use :split by. So you could use this as a data source for a repeating group or whatever you want to do

Screen Shot 2022-06-09 at 9.41.01 pm


Josh @ Support Dept
Helping no-code founders get unstuck fast :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

I post daily about no-code and Bubble on Twitter Follow Support Dept on Twitter

thanks Josh, i get how to split text, but how do I allocate each piece to a field in the table?

It’s a dynamic list from SEMrush right? I mean if it was a static data structure coming back each time you could literally map item#1, item#2 etc to particular fields (or search). Or perhaps you do that until you get to Date and then put everything else beyond that into a list in a single field?


Josh @ Support Dept
Helping no-code founders get unstuck fast :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

I post daily about no-code and Bubble on Twitter Follow Support Dept on Twitter

Thanks Josh… No the data structure is the same every time, but there are multiple rows of each, so I guess I need to iterate through this somehow

Perhaps a backend workflow with a loop? Have you gone down that dark alley yet? :joy:


Josh @ Support Dept
Helping no-code founders get unstuck fast :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

I post daily about no-code and Bubble on Twitter Follow Support Dept on Twitter