Data for SEO Api, into a database

[rob17]

Hi,

I’m pulling in data from a DATAforSEO Api.

And I have a few challenges.

1. The data coming into the database is all in one row, rather than breaking this down.
2. When i try to schedule api workflow for list. I don’t know what I am actually running the list on. I have tried “Result of step X (API Call)'s tasks:first item’s result’s items”, but its just red!

Workflow works like this.
Ignore steps 1 and 2, thats another workflow trigger that works fine.

Step 3

Step 4: Attempt 1: as you can see i can’t format the numbers in here.

Step 5: Attempt 2: List to run on doesn;t pull from result of step 3 correctly?

Backend Workflow:

Database Setup…

Any help would be greatfully appreciated!

[romanmg]

I think you’re closer with attempt 2 by changing the list you’re running on. See if you’re able to set the list expression to “result of step 3’s tasks: each item’s result’s items” and then you’ll need to change “type of things” to match the content format of “results items.”

Once you have that in place, then for each parameter, you should be able to send “this item’s [field]” For example, this item’s target or this item’s keyword. These would not be list values. The list structure is already addressed by running the workflow on the list of “result items.”

In other words, if you have 100 “result items,” then you’re running the backend workflow 100 times. For each run, you’re creating a new record, saving different (single) values to each field per record.

Check out this video for some quick context on the “schedule on a list” action: https://www.youtube.com/watch?v=LLYaNHmt6_Y

Hope this gets you going in the right direction!

Cheers,
Gaby
Coaching No Code Apps

[rob17]

So the type of thing is the database I want to export the api too?

List to run, I have done this, but its still red?

I followed the video but im still having issues as to why the list to run on is still only showing red?

[romanmg]

“Type of things” is the format of your list. So, for example, if you were running on a list of users:

Type of things: User
List to run on: Search for Users

Or, if you were running on a list of numbers coming from an API result…

Type of things: number
List to run on: Result of previous step’s task’s each item’s result’s item’s price

Again, these are just examples. The type of things is the format. The list to run on has to be a list of values that matches that format. The format can be API specific, so it doesn’t need to be a generic text, number, date, etc. I don’t know enough about the architecture of the API you’re using, but you’ll need to locate the format that matches that list you have (currently in red).

Sometimes, Bubble will show a little message to help you auto-select the right type. If you see that pop up when you change the list expression, try selecting Bubble’s suggestion. Also, it’s possible that the list you have now (in red) isn’t the one you actually need. It’s the one I’d start with based on your other screenshots to find the best pathway to all those other values.

So, I’d keep the list you have and change the type to a selection that matches your list (which you’ll know is correct once the expression turns blue).