I have been stuck on a problem since last night, hope someone can help me navigate this.
I am running an API Workflow on a list called refresh_youtube that uses information from a dataview called “creators” in order to populate another view called “youtube_extract”.
The workflow uses two fields from creators: name and channel ID.
Using that same ChannelID, it retrieves the video_id , date, and title from all the videos from that ChannelID through an API call to Youtube.
The workflow works but creates only one row per run with all the video informations in it, which makes the data unusable to me…
I have another workflow called “add_creator_youtube” that is used to create a “creator” item and import the first 20 videos which works just fine and shows me results like I want to for reference:
How can I fix the previous workflow to make it work like this one?
I am able to create new entries proprely from a repeating group but not from a search from the data view directly.
It looks like you have api calls in each parameter for video ID data and title
This will return a list for each, and hence save everything in one row with a whole bunch of items
What you need to do is make the “GetYoutubeVideos - API Call” once per item of “search for creators”
So you need two “schedule api workflow on a list” actions here, one for the list of “search for creators” and one for each item that gets returned from “GetYoutubeVideos - API Call”
so lets say you have creators A B and C
You run a workflow called Make API call, and this is scheduled to run on the list of creators
So, for creator A, you make the API call once, and then schedule an api workflow on the JSON list that comes back, for each item, you create your entries etc…
then you move on to creator B, make the api call etc etc
Trying to make that work, but I can;t figure out how to pass the information from the 1rst workflow to the second…
I logically wanted to create two steps in a workflow:
Step 1 - > search for the creators
Step 2 - > Make the API Calls
The logic seems right to me but I can’t use the results of step 1 in “List to run on”:
The error for bubble is that the list to run on should a list of creators but right now is a list of text.
I guess the results from Step 1 are sent in an array as well:
I even tried to modify step 1 in order to search only for the channelid which is the only true parameter I need for the API call so that I only have one field in the search and, but without success as well
What am I missing here? Maybe I shouldn’t use steps? But if yes how can I pass the results of the search workflow to the API call one?
Thanks a lot for your time!
The error for bubble is that the list to run on should a list of creators but right now is a list of text.
Already tried to swap it it text, unfortunately it makes the call have a 400 error, nothing happens.
Me again
After spending hours trying different workflows, even a plugin I still can’t make it work.
I’ve also tried to extract the entries using a regex, the List Popper And Friends plugin, tried to work with text and list of text data types, nothing
I must be missing something important but can’t see what…