1

I need to get all data of a specific table using salesforce in one go. Is there any API to do so?

2

If you need details of the different Salesforce APIs the starting point for the documentation is here. Salesforce supports REST and SOAP API with a number of specialised API for the Metadata used in deployment, Chatter and for the APEX development language. Please start there to find out the different API and ask specific question here as they arise.

To just extract data from an object the free Salesforce Data Loader tool is able to do this and is documented here. Data Loader uses the API to extract data and can be used for both standard and custom object's data.

| improve this answer | |
0

If you are using the SOAP API, there are two ways to get data from a data extension.

  1. Retrieve Requests, can retrieve up to 2500 records per request. This is recommended for data extensions less than 50,000 records. See: https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/retrieving_data_from_a_data_extension.htm

  2. Extract Requests, which will export the entire DE to a file in the related FTP account. See the following for examples: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/creating_a_data_extract_activity_with_the_soap_web_service_api.htm

If using an Extract Request, ensure that the extract ID = bb94a04d-9632-4623-be47-daabc3f588a6, use the DECustomerKey parameter to specify the DE and include all other required parameters.

| improve this answer | |
0

Its possible with REST API

https://[YOURDOMAIN].rest.marketingcloudapis.com/data/v1/customobjectdata/key/[EXTERNALKEY-DATAEXTENSION]/rowset

With this URI above you can to retrieve until 2500 records, but in the response exist a link to the nexts 2500 records.

So you can to paginate this datas /v1/customobjectdata/token/e05b8be5-94ea-4147-af3e-4ec2b40a7d12/rowset?$page=1

Response Example :

{
"links": {

"self": "/v1/customobjectdata/token/e05b8be5-94ea-4147-af3e-4ec2b40a7d12/rowset?$page=1",

"next": "/v1/customobjectdata/token/e05b8be5-94ea-4147-af3e-4ec2b40a7d12/rowset?$page=2"


    },
    "requestToken": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "tokenExpireDateUtc": "2019-06-10T20:11:56.523",
    "customObjectId": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "customObjectKey": "xxxxxxxxxxxxxxxxxxxxxxxx",
    "pageSize": 2500,
    "page": 1,
    "count": 2506,
    "items": [
        {
| improve this answer | |

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.