Splitting API data

Need help
1

Hope someone can point me in the right direction.

I am importing data from DataforSEO API and need to split into individual rows. I am using a backend workflow to achieve this but encountered an issue.

I have set the API as below:

image
image893Ă—415 19.7 KB

But I cannot get the List to run on the API:

image
image1462Ă—818 41.3 KB

This is the API data returned:

  "version": "0.1.20240514",
  "status_code": 20000,
  "status_message": "Ok.",
  "time": "0.1326 sec.",
  "cost": 0.0103,
  "tasks_count": 1,
  "tasks_error": 0,
  "tasks": [
    {
      "id": "06031545-7892-0399-0000-8dbe7d23b279",
      "status_code": 20000,
      "status_message": "Ok.",
      "time": "0.0612 sec.",
      "cost": 0.0103,
      "result_count": 1,
      "path": [
        "v3"
      ],
      "data": {
        "api": "dataforseo_labs",
        "function": "keyword_suggestions",
        "se_type": "google",
        "keyword": "null",
        "location_code": 2826,
        "language_code": "en",
        "include_serp_info": true,
        "include_seed_keyword": true,
        "limit": 3
      },
      "result": [
        {
          "se_type": "google",
          "seed_keyword": "null",
          "seed_keyword_data": {
            "se_type": "google",
            "keyword": "null",
            "location_code": 2826,
            "language_code": "en",
            "keyword_info": {
              "se_type": "google",
              "last_updated_time": "2024-05-10 11:12:13 +00:00",
              "competition": null,
              "competition_level": "LOW",
              "cpc": null,
              "search_volume": 12100,
              "low_top_of_page_bid": null,
              "high_top_of_page_bid": null,
              "categories": [
                10019
              ],
              "monthly_searches": [
                {
                  "year": 2024,
                  "month": 4,
                  "search_volume": 14800
                }
              ]
            },
            "impressions_info": {
              "se_type": "google",
              "last_updated_time": "2022-04-17 22:35:50 +00:00",
              "bid": 999,
              "match_type": "exact",
              "ad_position_min": 1.11,
              "ad_position_max": 1,
              "ad_position_average": 1.06,
              "cpc_min": 33.73,
              "cpc_max": 41.23,
              "cpc_average": 37.48,
              "daily_impressions_min": 0.14,
              "daily_impressions_max": 0.17,
              "daily_impressions_average": 0.15,
              "daily_clicks_min": null,
              "daily_clicks_max": null,
              "daily_clicks_average": null,
              "daily_cost_min": 0.08,
              "daily_cost_max": 0.1,
              "daily_cost_average": 0.09
            },
            "serp_info": {
              "se_type": "google",
              "check_url": "https://www.google.co.uk/search?q=null&num=100&hl=en&gl=GB&gws_rd=cr&ie=UTF-8&oe=UTF-8&glp=1&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE",
              "serp_item_types": [
                "featured_snippet"
              ],
              "se_results_count": 1430000000,
              "last_updated_time": "2024-05-13 13:50:12 +00:00",
              "previous_updated_time": "2024-04-02 01:27:59 +00:00"
            },
            "keyword_properties": {
              "se_type": "google",
              "core_keyword": null,
              "synonym_clustering_algorithm": "text_processing",
              "keyword_difficulty": 60,
              "detected_language": "en",
              "is_another_language": false
            },
            "search_intent_info": {
              "se_type": "google",
              "main_intent": "informational",
              "foreign_intent": null,
              "last_updated_time": "2023-03-13 21:29:20 +00:00"
            },
            "avg_backlinks_info": {
              "se_type": "google",
              "backlinks": 763.6,
              "dofollow": 687.2,
              "referring_pages": 727.6,
              "referring_domains": 46.3,
              "referring_main_domains": 39.2,
              "rank": 202.5,
              "main_domain_rank": 697.6,
              "last_updated_time": "2024-05-13 10:50:13 +00:00"
            }
          },
          "location_code": 2826,
          "language_code": "en",
          "total_count": 12040,
          "items_count": 3,
          "offset": 0,
          "offset_token": "eyJDdXJyZW50T2Zmc2V0IjozLCJSZXF1ZXN0RGF0YSI6eyJrZXl3b3JkIjoibnVsbCIsImluY2x1ZGVfc2VlZF9rZXl3b3JkIjp0cnVlLCJmdWxsX21hdGNoIjpmYWxzZSwibG9hZF9zZXJwX2luZm8iOnRydWUsInNlYXJjaF9hZnRlcl90b2tlbiI6bnVsbCwiaWdub3JlX3N5bm9ueW1zIjpmYWxzZSwibGFuZ3VhZ2UiOiJlbiIsInNlYXJjaF9lbmdpbmUiOiJnb29nbGUiLCJsb2NhdGlvbiI6MjgyNiwidXNlX25ld19jYXRlZ29yaWVzIjp0cnVlLCJvcmRlcl9ieSI6eyJvcmRlcl9maWVsZCI6ImtleXdvcmRfaW5mby5zZWFyY2hfdm9sdW1lIiwib3JkZXJfdHlwZSI6IkRlc2MiLCJuZXh0IjpudWxsfSwibGltaXQiOjMsIm9mZnNldCI6MCwiYWlkIjo3ODkyMH0sIlJhd1F1ZXJ5IjpudWxsLCJJZCI6IjYyNTdjYTkxLWIwOTAtNDcxNi05YzE4LWMwMjdmN2FhY2Q3ZCIsIlNlYXJjaEFmdGVyRGF0YSI6WzgxMDAsIjdlZmNkYzFhLTM2NWUtZTgzZC1mNDJkLTBlYWY5ZThhYmQxNiJdfQ==",
          "items": [
            {
              "se_type": "google",
              "keyword": "null",
              "location_code": 2826,
              "language_code": "en",
              "keyword_info": {
                "se_type": "google",
                "last_updated_time": "2024-05-10 11:12:13 +00:00",
                "competition": null,
                "competition_level": "LOW",
                "cpc": null,
                "search_volume": 12100,
                "low_top_of_page_bid": null,
                "high_top_of_page_bid": null,
                "categories": [
                  10019
                ],
                "monthly_searches": [
                  {
                    "year": 2024,
                    "month": 4,
                    "search_volume": 14800
                  }
                ]
              },
              "keyword_properties": {
                "se_type": "google",
                "core_keyword": null,
                "synonym_clustering_algorithm": "text_processing",
                "keyword_difficulty": 60,
                "detected_language": "en",
                "is_another_language": false
              },
              "impressions_info": {
                "se_type": "google",
                "last_updated_time": "2022-04-17 22:35:50 +00:00",
                "bid": 999,
                "match_type": "exact",
                "ad_position_min": 1.11,
                "ad_position_max": 1,
                "ad_position_average": 1.06,
                "cpc_min": 33.73,
                "cpc_max": 41.23,
                "cpc_average": 37.48,
                "daily_impressions_min": 0.14,
                "daily_impressions_max": 0.17,
                "daily_impressions_average": 0.15,
                "daily_clicks_min": null,
                "daily_clicks_max": null,
                "daily_clicks_average": null,
                "daily_cost_min": 0.08,
                "daily_cost_max": 0.1,
                "daily_cost_average": 0.09
              },
              "serp_info": {
                "se_type": "google",
                "check_url": "https://www.google.co.uk/search?q=null&num=100&hl=en&gl=GB&gws_rd=cr&ie=UTF-8&oe=UTF-8&glp=1&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE",
                "serp_item_types": [
                  "featured_snippet"
                ],
                "se_results_count": 1430000000,
                "last_updated_time": "2024-05-13 10:50:12 +00:00",
                "previous_updated_time": "2024-04-01 22:27:59 +00:00"
              },
              "avg_backlinks_info": {
                "se_type": "google",
                "backlinks": 763.6,
                "dofollow": 687.2,
                "referring_pages": 727.6,
                "referring_domains": 46.3,
                "referring_main_domains": 39.2,
                "rank": 202.5,
                "main_domain_rank": 697.6,
                "last_updated_time": "2024-05-13 10:50:13 +00:00"
              },
              "search_intent_info": {
                "se_type": "google",
                "main_intent": "informational",
                "foreign_intent": null,
                "last_updated_time": "2023-03-13 21:30:20 +00:00"
              }
            }
          ]
        }
      ]
    }
  ]
}```

I've also followed this tutorial and I get as far as adding the list and cant validate the input: https://www.youtube.com/watch?v=4CE21Xn7fgI
2

Can you use ``` around your json so we can copy it and beautify it? Actually, it’s hard to read.
I guess actually “Keyword Suggestion” is the DB thing you want to create, but the list you run the schedule API need to be of the type of the API List, not the type of what you want to create. This is why actually it’s not working. It should be something like dataforseo’s key’s task’s result

3

Apologies. Done.

Yes that is correct. The Keyword Suggestion is the DB input and the content taken is essentially just the results section

4

So change this field for the API type list

5

On the page Scheduled API workflwow? It’s set to Keyword Suggestion API results which is taken from the DataforSEO api

6

No, the first dropdown (type of thing) is not set as the API type but on the DB type. Change that for the API type list

7

Ah great. Thanks. I have ran it and its not splitting the content:

image
image1544Ă—140 8.59 KB

image
image349Ă—800 22.8 KB

8

I think you are not going far enough into you list.
What I see is that you are fetching keyword list, but you are stoping at result in Type of things and List to run on. So probably result’s item is the list you are fetching?

9

OK I see. The list I need is under Result, Items but can’t seem to expose this to access.

10

Can you share your app editor link in public view mode?

11

I’ve managed to do it…you were correct. Used the Items API and there we have it.
Thanks so much. :grinning:

1 Like
12

This topic was automatically closed after 70 days. New replies are no longer allowed.