RecordsCount

  • 64Views
  • Last Post 19 August 2021
  • Topic Is Solved
0
votes
Avensia ITsupport posted this 11 August 2021

Hi, we have a problem with a SQL query: SELECT * FROM dbo.SFDCMargin WHERE AvensiaCustomerNumber = 'SE01-C00001'  Where the result reutned contains more then 500 rows we only get the first 500 rows in the repsonse. then we get this message: {

"recordsCount": 500,

"nextPageToken": "7e90fc9a04ad4bcabff7144dc2******",

"data": [

{.....}

]

Is there any way to increase the number of rows? if not, where can I find the documentation on how to access the next records?

Order By: Standard | Newest | Votes
1
votes
Olena Romanchuk posted this 12 August 2021

 Hello, 

Thank you for contacting our Skyvia support team.
Could you please clarify if this result is returned in Skyvia Query UI directly? 
Or you are using Skyvia Query Excel Add-in or Google Sheets Add-on? 

We look forward to your reply. 

  • Supported by
  • Avensia ITsupport
0
votes
Avensia ITsupport posted this 12 August 2021

It is a direct query run from salesforce. using the sql endpoint.

'

0
votes
Olena Romanchuk posted this 16 August 2021

Hello, 

Sorry for the delayed response.

We have investigated the issue more clearly.
In this case the issue is related to Salesforce batch limits.

You can find the recommendation regarding it here 
https://stackoverflow.com/questions/7271294/salesforce-query-returns-only-500-rows-when-more-exist  

or here https://developer.salesforce.com/forums?id=906F00000008sIVIAY#stq=querymore&stp=1

0
votes
Avensia ITsupport posted this 16 August 2021

Thansk for the responce, i will forward the links to the deveolper, I will get back to you shortly

0
votes
Avensia ITsupport posted this 16 August 2021

Hi, now my developer has run the query from Postman ( to ellimintae salesforce from the equation)  and still get the same limitation to 500 rows. so there seems to be some sort of setting in the skyvia endpoint that retrieves the data in groups of 500 rahter then getting all rows. 

0
votes
Olena Romanchuk posted this 18 August 2021

Hello,

We have checked such behavior on our side again,

You are right, SQL endpoint gets 500 records by default.

To get other records, the "nextPageToken" parameter may be used in the request.

In this case you will get the data from the next page.


Or you can set the specific page size in the request body and extend the page size:

Please inform us if it works for you. 


Best regards,
Olena
Support Engineer

 

 

0
votes
Avensia ITsupport posted this 18 August 2021

That did the trick, thanks for all help.

/Per

0
votes
Olena Romanchuk posted this 19 August 2021

Great news, thank you for informing us. 
Please contact us in case of any questions. 

Close