paul25
June 9, 2022, 11:31am
1
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
How would I parse these and create records in a table with the same fields?
Any help appreciated.
josh24
June 9, 2022, 11:42am
2
Use :split by. So you could use this as a data source for a repeating group or whatever you want to do
Josh @ Support Dept
I post daily about no-code and Bubble on Twitter
paul25
June 9, 2022, 12:19pm
3
thanks Josh, i get how to split text, but how do I allocate each piece to a field in the table?
josh24
June 9, 2022, 12:26pm
4
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
I post daily about no-code and Bubble on Twitter
paul25
June 9, 2022, 12:34pm
5
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?
Josh @ Support Dept
I post daily about no-code and Bubble on Twitter
save hours, & ship faster with an expert 
on-demand
