Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Dynamically parse the excel without having sheet index or sheet name

Hi, Anyone aware of how do we parse the excel with multisheet without even knowing sheet index / sheet name with having certain number of records in each sheet. I am having requirement to remove ...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago
Copy LinkReport

Hi @sravan,

Even though the API does not support pagination, I think we can leverage of the pagination option in the Rest Get snap. There is a Pagination Interval option, which basically means “Wait for X seconds before doing the next request”.

The logic would be something like:

HasNext: parseInt($records_remaining) > 0
NextURL: https:abc.com/8080/getfullload?batch=50

Let me know if this helps,

Regards,
Bojan

  • vamsi's avatar
    vamsi
    New Contributor II
    4 years ago
    Copy LinkReport

    Thank you @bojanvelevski It worked like a charm…

    The second one needs some adjustments in terms of what was required but both can be used for the requirement.

    You are a RockStar.