How to specify Query Parameter for Import and Export

How to specify Query Parameter for Import and Export

Oracle Eloqua: How to specify Query Parameter for Import and Export

If you want to export or import records in bulk, you will have to specify the Query parameter in JSON format as mentioned in Oracle Eloqua documentation here in Rest Source(Export) or Rest Destination(Import) to start the import/export job. The JSON payload contains double open ( {{ ) and closing ( }} )  curly brackets for the fields value as mentioned in Oracle Documentation but using COZYROC Rest Source/Rest Destination Component you will have to replace the open curly brackets with the symbol ( < ) and closing curly brackets with symbol ( > ). See below example for the sample json payload for Query Parameter

            {
               "name":"Example Activity Export",
               "fields":{
                  "ActivityId":"<Activity.Id>",
                  "AssetName":"<Activity.Asset.Name>"
               },
               "filter":"'<Activity.Type>'='FormSubmit'"
            }


    • Related Articles

    • How to dynamically set a user parameter in a REST Connection.

      Create a REST Connection with a custom configuration to use for our example. Let’s start by creating a REST Connection configuration that has authentication with two user parameters. We will set their values dynamically from variables using an ...
    • Why the buttons on the REST Connection manager are missing?

      Problem: I am not able to configure my REST Connection Manager component. After I select "Configuration", the buttons on the REST Connection manager screen are gone, they are missing . Look at the screenshot below: Solution: A possible reason for ...
    • How to use a Database storage for new REST tokens

      Make sure you have launched Visual Studio as "Run as Administrator". 1 : In Rest Connection Manager choose the configuration from the dropdown list you want to generate token for. 2: For the Token storage parameter in the grid below select Database ...
    • How to select OpenAPI/Swagger file using COZYROC OpenAPI Import Wizard

      The OpenAPI import wizard (introduced in 2.0 release) enables quick, automated creation of resources, endpoints, parameters and fields from an OpenAPI specification (formerly Swagger specification). To learn more about OpenAPI see here. By following ...
    • Where can I find the documentation for the REST Connection?

      You can find documentation related to all the COZYROC SSIS+ Suite components from the main products page.  Specific documentation for the REST Connection Manager can be found at the following link.  For many of the components you can find an ...