How to Configure REST Adapter to Extract Bulk Leads from Marketo

Create REST Connection

1. Select Connection Type : REST API Base URL.
2. Connection URL:  https://{Munchkin ID}.mktorest.com/
3. Select Security Policy as: OAuth Client Credentials and provide below details:
   1. Access Token URI: https://{Munchkin ID}.mktorest.com/identity/oauth/token
   2. Client Id
   3. Client Secret

Create Integration

• Select Scheduled Orchestration Integration Pattern in OIC.
• Drag and drop Configured Rest Adapter Connection.

Steps to configure:

1. Provide URI to Create a job:  /bulk/v1/leads/export/create.json 
2. Select POST action.
3. Select request payload and Configure the endpoint to receive the response from available options.
4. On Request Page, Select JSON request payload format and JSON media type and enter sample JSON.
5. On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
6. In the mapper, do required mappings.

• Drag and drop Configured Rest Adapter Connection again on orchestration

Steps to configure:

1. Provide URI to Enqueue the created job:  /bulk/v1/leads/export/{exportId}/enqueue.json
2. Select POST action.
3. Select Add and Review parameters and Configure the endpoint to receive response from available options.
4. On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
5. Do the required mapping

• Drag and drop Wait Activity and Provide Wait time in minutes since it takes some time to return Status of Job as Complete
• Drag and drop third time Configured Rest Adapter Connection on Orchestration canvas

Steps to configure:

1. Provide URI to Get the Status of job:  /bulk/v1/leads/export/{exportId}/status.json
2. Select GET action.
3. Select Add and Review parameters and Configure the endpoint to receive response from available options.
4. On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
5. Do required mapping.

• Drag and drop Switch activity, check for the status of Job.
• IF status=”Completed” then
• Drag and drop forth instance of Configured Rest Adapter Connection

Steps to configure:

1. Provide URI to Get the contents of file:  /bulk/v1/leads/export/{exportId}/file.json
2. Select GET action.
3. Select Add and Review parameters and Configure the endpoint to receive response from available options.
4. On Response Page, Select Binary response payload format from the dropdown.
5. Select application/octet-stream media type from drop down.
6. Do required mapping

• Drag and drop FTP adapter

Steps to configure:

1. On the Basic Info page, provide a name.
2. On the Operations page, select Write File from the Select Operation list. Select ASCII from the Select a Transfer Mode list.
3. Specify the output directory, file name pattern.
4. On the Scheme page, select No for Do you want to specify the structure for the contents of the file?
5. Review your selections on the Summary page

• In the mapper, map FileReference.
• Specify the tracking variable.
• Click Tracking.
• Drag the required variable to use for the tracking reference (for this example, startTime is selected)
• Activate the Integration.
• After successful activation, you can submit the integration and monitor the runtime in Oracle Integration