Skip to content
Create REST Connection
- Select Connection Type : REST API Base URL.
- Connection URL: https://{Munchkin ID}.mktorest.com/
- Select Security Policy as: OAuth Client Credentials and provide below details:
- Access Token URI: https://{Munchkin ID}.mktorest.com/identity/oauth/token
- Client Id
- Client Secret
Create Integration
- Select Scheduled Orchestration Integration Pattern in OIC.
- Drag and drop Configured Rest Adapter Connection.
Steps to configure:
- Provide URI to Create a job: /bulk/v1/leads/export/create.json
- Select POST action.
- Select request payload and Configure the endpoint to receive the response from available options.
- On Request Page, Select JSON request payload format and JSON media type and enter sample JSON.
- On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
- In the mapper, do required mappings.
- Drag and drop Configured Rest Adapter Connection again on orchestration
Steps to configure:
- Provide URI to Enqueue the created job: /bulk/v1/leads/export/{exportId}/enqueue.json
- Select POST action.
- Select Add and Review parameters and Configure the endpoint to receive response from available options.
- On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
- 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:
- Provide URI to Get the Status of job: /bulk/v1/leads/export/{exportId}/status.json
- Select GET action.
- Select Add and Review parameters and Configure the endpoint to receive response from available options.
- On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
- 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:
- Provide URI to Get the contents of file: /bulk/v1/leads/export/{exportId}/file.json
- Select GET action.
- Select Add and Review parameters and Configure the endpoint to receive response from available options.
- On Response Page, Select Binary response payload format from the dropdown.
- Select application/octet-stream media type from drop down.
- Do required mapping
- Drag and drop FTP adapter
Steps to configure:
- On the Basic Info page, provide a name.
- On the Operations page, select Write File from the Select Operation list. Select ASCII from the Select a Transfer Mode list.
- Specify the output directory, file name pattern.
- On the Scheme page, select No for Do you want to specify the structure for the contents of the file?
- 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
Like this:
Like Loading...
Related