ARBGetSubscriptionList - Grab more than 1000? How to?

[MEHUL01]

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]

How are you sorting it?

http://developer.authorize.net/api/reference/index.html#recurring-billing-get-a-list-of-subscription...

[MEHUL01]

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

I've been doing "Amount"

[MEHUL01]

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 · Accepted solution]

If you click on the link

http://developer.authorize.net/api/reference/index.html#recurring-billing-get-a-list-of-subscription...

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]

Alright thanks. 

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

[RaynorC1emen7]

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

[MEHUL01 · Accepted solution]

Cool thx!