I am still trying to figure out how to handle YouTube api pageToken

[bradbrd992]

Wappler Team I need some help in understanding what is the best way to return more than the default 50 items the YouTube api gives using the pageToken parameter from the YouTube api documentation. So far a few members of the Wappler community has tried to help me on this given a few times that I have reach out here in the community, but from our observation it seems the “While” in Core Actions cannot handle or refused to loop through the YouTube api using the pageToken=nextPageToken that we have set to global and use as one of the “While” condition.

Here is a simple image showing the setup of what should cause the “While” to loop through the api call to get more than 50 items but it seems its not working.

[sbecks]

Hi,
I’ve had a look through this as I need to use the YouTube API shortly.

I think it works fine within the while loop, but may not give the results you’re expecting to see… the API will only ever return the final set of results in the browser (so if your maxResults is 50 you will only ever see the final 50 results).

Though the query does retrieve more results, you’ll need to repeat them and save them somewhere to access the previous results sets.

To use the pagination practically you need to either:

Repeat the results and save each call somewhere to access all the looped values.

For example this calls the API twice and retrieves 10 records each time

the action inserts 20 records to the db (which could then be queried and returned):

but only the final 10 results show in the browser from the API.

or

add buttons to your page which call the API again and use the nextpagetoken or prevpagetoken so the user can cycle through the results. So you display x number of results in the page at any one time, add a GET variable to the API call to process the tokens.

Hope that helps a bit, if not if you can share a little more of your use case?

[bradbrd992]

Thanks for this info.

Now this begs the question, does Wappler have a way to save the result of an API in an array server side much like they do here for client side? ( Wappler Documentation - Working with Arrays)

[brad]

@George

Array component and Data store is indeed for client side only.

From this thread …

Arrays - server side

Hm… Interesting! It seems this is only for client-side stuff? (App Connect) I can’t find this how to do this server-side, do you know if this is possible?

[bradbrd992]

So, my best bet is to save the responses in a database then and forget about trying to use an array?

[sbecks]

Arrays - server side

How I push objects into arrays: [image] Define the array with Set Value name = Data Inside a repeat: create an object with Set Value, and in my case: {{{Name:mj_property_name,Value:mj_property_value}}} (values come from the query I am putting in the repeat) Inside same repeat: push it to the array using `Data.push(obj) Now your data should be pushed into the array Note: I am not sure if this formatter already exists in Wappler, but isn’t in the UI. I might’ve made it myself. Eit…

RunJS 1.2.0

Inspired by @Apple And very thankful for his insights and ideas I just released a custom extension for nodejs to run custom js code without having to create a custom module or a formatter. Sometimes for small quick things you just don’t want to go through the hassle of creating a full extension for a very specific thing that could be easily achieved in a few seconds of writing some JS code. There are also other cases where a custom extension will serve the purpose for a very specific case bu…

These could both be good options to achieve an output as an object/array if you’re using Node JS. The top one has been assigned to @patrick so the functionality may be coming along in Wappler some time soon? This is a good use case, but I’m sure there are others.

This would probably be faster than writing to the DB in your server action, I guess it depends if there’s any value in having the results saved more permanently?

If on PHP you could use a custom formatter too using:

https://www.php.net/manual/en/function.array-push.php

or similar.

[bradbrd992]

Thanks for this info. Well, I cannot wait to see what Wappler come up for getting objects in an array server side.