Loop through URL with IDs

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a URL like:

It contains something like:

{id=001;name='john';age=55},{id=002;name='jack';age=48}

What I need is to LOOP that URL, load the string, get the last ID (in this case it's id=002) and use it again like this:

Then I'd have something like this:

{id=003;name='pat';age=55},{id=004;name='user';age=48}

I need to Loop on that URL (look for the last id value in the string and store it on a variable? and use it on the load)

I know there's no more data because for example if I do http://link.com/start_id=3000 I get this: []

Do you know how could I do that?

Thank you!!

topic Loop through URL with IDs in QlikView