Discussions

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

Rohit Abburi
Rohit Abburi Posts: 2 Red Ribbon
edited Mar 16, 2020 6:41PM in Developer Tools

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

Post edited by Unknown User on
Tagged:

Answers

  • Lou Patrick
    Lou Patrick Posts: 194 Bronze Trophy
    edited Mar 16, 2020 6:41PM

    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.