Odata connection paginated and missing the input for next page

Question

Hi all,

I was able to create a workflow to retrieve data via an Odata connection from a source system. However the content seems to be paginated to 100 records at once. I have also found a solution in form of an iterative macro how it could be solved, but there seems to be an input needed for this macro from the Odata connection which would lead the macro to find the "next page".

This is my original workflow:

This is working properly, but only for 100 record:

Here is the iteration macro I have found also in the community:

As you can see this iteration macro would need the "result._links.next" in order to continue with the iteration.

When I have tried to apply this macro to my current workflow (of course replacing the links to my particular one), I have faced the problem that among the DownloadData I got only the odata context, but I don't receive the odata next link, so there is no link for the next "page", what could be the input for the iteration macro.

Do you have any idea if there could be any settings adjusted in the workflow, or this is rather something that should be handled from the data provider side?

The configuration of my Download tool:

Thanks in advance!

Best regards,

Antal

apathetichell · Answer

@Tommy_Alterax --- what is the API you are using? as a reminder --- your credentials are your credentials --- they are secret. your endpoints --- those should be secret. The API documentation --- in 99.99% of situations that is public. That is from the SAAS system and that is usually not secret. If you let use know the system is really really helps.

Tommy_Alterax · Answer

Hi Guys -I am at the same stage - did you solve this ?

akarpati · Answer

Hello,

so this is my main URL (I have to blur certain details of it):

This gives me a list of 'tables' I can connect to (under value.x.name) and only one record with @odata.context, nothing else:

Shall I enter the URL differently?

Thanks,

Antal