When using QueryNext, where does the url parameter come from? about go-force HOT 5 CLOSED

You need to setup a QueryResponse struct.

e.g.

type AccountQueryResponse struct {
     sobjects.BaseQuery

     Records []*Account `force:"records"`
}

accounts := &AccountQueryResponse{}
err = fa.Query("SELECT Id, Name, BillingCity FROM Account LIMIT 10", accounts)

from go-force.

Nice, thanks. Worked a treat. Good work.

from go-force.

What if we need more than the 2,000 rows limited ? I was under the impression the QueryNext function could be used to iterate over in batches of 2,000 by using the uri of the last output as the input until there are no records left. Anyone know the proper way to do this with this package?

from go-force.

@moesy Untested code ahead :)

type AccountQueryResponse struct {
     sobjects.BaseQuery

     Records []*Account `force:"records"`
}

accounts := &AccountQueryResponse{}
err = fa.Query("SELECT Id, Name, BillingCity FROM Account LIMIT 10", accounts)
if err != nil {
	//DO Something
}

if accounts.NextRecordsUri != "" {
	moreAccounts := &AccountQueryResponse{}
	err = fa.QueryNext(accounts.NextRecordsUri, moreAccounts)
	if err != nil {
		//DO Something
	}
}

from go-force.

Thank's for quick response @nimajalali testing it now but locked out of salesforce for a bit (API Overage). One part I'm not able to test yet but assume will be problematic is I probably can't append moreAcounts to Records given how AccountQueryResponse.Records is declared, ("[]*")would you recommend simply create an array within the method and work it through that way To build a comprehensive list?

from go-force.