API Customer list over 250 limit

Retired Boards Appdev Tools
1

Hi need download the lasta 10000 customer but the api call not accept the order by id and I can’t see the begining… i see only the last 250…

the variable @Ultimo is always the last.. I need the first and after see the next 250… the order with “since_id” go to error

if (@primo > 0)
	begin
		select  = max(id) from ##cliente
		set @url = +'/admin/api/2023-10/customers.json?limit=250&since_id='+convert(varchar(20), )
	end
	else
	begin
		set @url = +'/admin/api/2023-10/customers.json?order=id&limit=250'
	end
2

resolved…

if (@primo > 0)
	begin
		select  = max(id) from ##cliente
		set @url = +'/admin/api/2023-10/customers.json?limit=250&since_id='+convert(varchar(20), )
	end
	else
	begin
		set @url = +'/admin/api/2023-10/customers.json)limit=250&since_id=1'
	end