Retrieving app records using the bulk API from a step in an active canvas

Rohit Abburi

Hi,

I am developing an action service app compatible to deal with large volumes of data, instead of getting data from HTTP POST request from Eloqua, i wanted to use a single BULK export to retrieve all the records by setting Records per Notification as 0 and following the steps mentioned in this documentation provided by Oracle.

Even though the documentation suggests all the records can be retrieved through a single BULK export, the records are arriving to the step in the batches of 5000.

For e.g., If i have a total of 20,000 records in the step, i am receiving 4 notification calls of 5000 each with different Execution IDs.

Is there a way to get all the records through a single notification call with a single execution ID??

Thanks in Advance.

@Lou Patrick

Lou Patrick

Just remove the execution id from the STATUS filter statement to retrieve all pending in a step. Here is an updated definition request using the example in the tutorial:

POST https://secure.p03.eloqua.com/api/bulk/2.0/contacts/exports{    "name": "Awesome App Contact Export - f82d50cd-86a9-4fca-b37e-4ec9a98b0339 - All Executions",    "fields": {        "emailAddress": "{{Contact.Field(C_EmailAddress)}}"    },"filter": "STATUS('{{ActionInstance(f82d50cd86a94fcab37e4ec9a98b0339)}}') = 'pending'" }

The execution id will also need to be removed from the import or sync action to update the status, as you will not know which record is in which execution.