0

I am trying to retrieve around 40,000 rows from my Data Extension into a CloudPage for an external 3rd party to consume this data.

The loading time of my cloudpage exceeds 2min, and it makes a timeout.

I would like to know if there is a function in SJSS to index the lines of my dataextension, like that, with each refresh, it recovers and treats just the new lines of my dataextension.

Any suggestions what the best method here would be?

Thanks in advance.

4
  • Does the third party software or product have the possibility to use the rest or soap api of salesforce? Then i would definitely go for this approach. Otherwise... how fast do you need the data - if its realtime use the apis. If you just need to import once a day or something like that, you can also cover it with automations and file exports to ftps. – Johannes Schapdick Jul 24 '19 at 8:18
  • Yes, the 3rd party needs to use the data in real time. They check the cloudpage every 2min. – mazgour abdellah Jul 24 '19 at 9:26
  • We can retrieve data from DE using Rest API ? – mazgour abdellah Jul 24 '19 at 9:26
  • It depends on your use case and how much data you want to receive. If you request millions of records and only have 2minutes of it, you will most likely fail with every api. So we would like to know more about the use case and the amount of data you need to grab. – Johannes Schapdick Jul 24 '19 at 10:19
2

This would definitely be better done having the third party access the API directly, and not via a cloud page. Adding in the CloudPage just brings in overhead that isn't necessary. Depending on the fields you have available in the DE, they could then query on something like a date/time added field to only get new items since they last checked.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.