topic Re: ARBGetSubscriptionList - Grab more than 1000? How to? in Integration and Testing

ARBGetSubscriptionList - Grab more than 1000? How to?

MEHUL01 — Tue, 30 Sep 2014 01:29:57 GMT

Hello,

Trying to grab more suscrbitions than 1000 at a time, I know this isn't possible so how do we accomplish this?

I've tired using the offset, and using 1, 2, 3, 4 ,5 etc... but it seems as the ARBs are duplicating the the offsets.

<v1:paging>
<v1:limit>1000</v1:limit>
<v1:offset>1</v1:offset>   <---- changed this from 1 to 5 and saved the XML but there are duplicate ARBs than.

Thanks!

RaynorC1emen7 — Tue, 30 Sep 2014 00:51:04 GMT

How are you sorting it?

MEHUL01 — Tue, 30 Sep 2014 15:53:42 GMT

Can you give me an example of how I should sort it?

I've been doing "Amount"

MEHUL01 — Tue, 30 Sep 2014 15:55:00 GMT

Should i use

<orderBy>id</orderBy>
<orderDescending>false</orderDescending>
</sorting>
<paging>
<limit>1000</limit>
<offset>1</offset>

and than keep adding to the Offset +1 every page

RaynorC1emen7 — Tue, 30 Sep 2014 15:59:38 GMT

If you click on the link

then

id, name, status, createTimeStampUTC, lastName, firstName, accountNumber, (ordered by last 4 digits only) amount, pastOccurences

if the amount is the same for a lot of them, you might be duplicate, if id is unqine then sure, it is better.

MEHUL01 — Tue, 30 Sep 2014 16:24:55 GMT

Alright thanks.

Any easier method to importing these into excel other than saving the XMLs and importing 1 by 1 in excel?

RaynorC1emen7 — Tue, 30 Sep 2014 19:12:08 GMT

Didn't see it any other way. Not thru the mechant account website. nor another API.

MEHUL01 — Tue, 30 Sep 2014 22:10:20 GMT

Cool thx!