Data for SEO Api, into a database

rob17 · 2025-01-06T13:54:41.070Z

Hi,

I’m pulling in data from a DATAforSEO Api.

And I have a few challenges.

The data coming into the database is all in one row, rather than breaking this down.
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!

Screenshot 2025-01-06 at 13.45.171524×689 117 KB

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

Screenshot 2025-01-06 at 13.51.221799×113 10.3 KB

Step 3

Screenshot 2025-01-06 at 13.51.50382×280 15.1 KB

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

Screenshot 2025-01-06 at 13.52.07373×897 54.2 KB

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

Screenshot 2025-01-06 at 13.52.34368×889 54.9 KB

Backend Workflow:

Screenshot 2025-01-06 at 13.53.37256×845 34.3 KB

Screenshot 2025-01-06 at 13.54.00289×439 14.5 KB

Database Setup…

Screenshot 2025-01-06 at 13.54.21529×488 25.2 KB

Any help would be greatfully appreciated!

romanmg · 2025-01-06T22:41:52.028Z

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 · 2025-01-07T13:35:03.059Z

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?

Screenshot 2025-01-07 at 12.36.47374×218 13.9 KB

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

romanmg · 2025-01-07T15:52:15.382Z

“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).