Use this resource to request the details of a D&B360 workflow or the details of all D&B360 workflows in the organization. You can also create or update a D&B360 workflow, and you can delete a D&B360 workflow. For Informatica Cloud D&B360 partners only.
GET Request
To request the details of a D&B360 workflow, use the following syntax. To view details of all D&B360 workflows, omit the optional workflow ID.
/api/v2/dnbWorkflow/<id>
GET Response
Returns the dnbWorkflow object for the requested D&B360 workflow. Or, if you requested information for all D&B360 workflows, returns the dnbWorkflow object for each D&B360 workflow in the organization.
The dnbWorkflow object includes the following attributes:
dnbWorkflow Object Response Attribute
Description
id Workflow ID.
orgId Organization ID.
name Workflow name.
description Description of the workflow. createTime When the workflow was created. updateTime When the workflow was last updated. createdBy D&B360 user who created the workflow. updatedBy D&B360 user who updated the workflow.
uname Workflow unique identifier. Returns one of the following values: - NewBatchSalesforceAccount - NewBatchOCODAccount - NewBatchOSCAccount - NewBatchMSDAccount - NewBatchSAPCRMAccount - RefreshBatchSalesforceAccount - RefreshBatchOCODAccount - RefreshBatchOSCAccount - RefreshBatchMSDAccount - RefreshBatchSAPCRMAccount - ImportBatchSalesforceAccount - ImportBatchOCODAccount - ImportBatchOSCAccount - ImportBatchMSDAccount - ImportBatchSAPCRMAccount
batchName Display name of the D&B360 batch that the D&B360 workflow belongs to. batchType Batch type for the D&B360 workflow. Returns one of the following values:
- NewBatch - RefreshBatch - ImportBatch
applicationType Type of application for the D&B360 workflow. Returns one of the following values: - Salesforce.
- OCOD. Oracle CRM On Demand. - OSC.
- MSD. Microsoft Dynamics CRM. - SAPCRM.
objectType Type of object for the D&B360 workflow. Returns one of the following values: - Account
rowLimit Row limit for the workflow. partnerProfile Partner profile code.
dnbWorkflow Object Response Attribute
Description
companyCustomObject Company custom object number. adminCustomObject Admin custom object number. leadCustomObject Lead custom object number. odbcUser ODBC user ID.
connections Returns the connection response object each connection used in the workflow. For more information, see the connection resource.
schedule Name of the schedule associated with the workflow. dnbTasks D&B360 tasks included in the workflow.
Includes the following information for each task in a dnbTask object.
id Task ID.
name Task Name. description Description. orderNum Order number.
POST Request
To update a D&B360 workflow, use the following URI. To create a D&B360 workflow, omit the optional workflow ID.
/api/v2/dnbWorkflow/<id>
With this URI, use the following attributes in the dnbWorkflow object.
dnbWorkflow Object Request Attribute
Required/ Optional
Description
uname Required Unique identifier for the workflow. rowLimit Optional Workflow row limit.
partnerProfile Optional The partner profile used by D&B360 for the SAP CRM package, such as INFA. Contact your SAP CRM administrator for a Partner Profile code.
SAP CRM D&B360 workflows only.
companyCustomObject Optional Oracle CRM On Demand Company custom object number. Enter a number between 1 - 10.
To get the number, login into your Oracle CRM On Demand instance and navigate to Admin > Application Customization > Customize Record Types. Omit the leading 0 when entering the number.
Oracle CRM On Demand D&B360 workflows only. adminCustomObject Optional Oracle CRM On Demand Admin custom object number.
dnbWorkflow Object Request Attribute
Required/ Optional
Description
To get the number, login into your Oracle CRM On Demand instance and navigate to Admin > Application Customization > Customize Record Types. Omit the leading 0 when entering the number.
Oracle CRM On Demand D&B360 workflows only. leadCustomObject Optional Oracle CRM On Demand Lead custom object number.
Enter a number between 1 - 10.
To get the number, login into your Oracle CRM On Demand instance and navigate to Admin > Application Customization > Customize Record Types. Omit the leading 0 when entering the number.
Oracle CRM On Demand D&B360 workflows only.
odbcUser Optional ODBC user ID for batch jobs that interact with Siebel CRM through an ODBC driver.
The ODBC user ID is a dedicated Siebel database account that the Secure Agent uses to access Siebel database tables.
Enter your user ROW_ID value. To get this value, run the following query on the Siebel CRM database:
Select ROW_ID from S_USER where LOGIN = <Secure Agent login name>. The default value is 0-1.
Siebel D&B360 workflows only. connectionId Required Connection ID.
connectionId2 Optional Additional connection ID. Used for SAP IDoc Writer connections. scheduleId Optional Schedule ID.
POST Response
Returns the dnbWorkflow object if the D&B360 workflow is successfully created or updated. Returns the error object if errors occur.
DELETE Request
To delete a D&B360 workflow, use the D&B360 workflow ID in the following URI.
/api/v2/dnbWorkflow/<id>
DELETE Response
Returns no response if the request is successful. Returns the error object if errors occur.