GET api/workflowAction/GetExecuteSqlForWorkflow?accountID={accountID}&workflowItemID={workflowItemID}&metaValue_ActionFlowGroupID={metaValue_ActionFlowGroupID}&isAutomatic={isAutomatic}

Request Information

URI Parameters

Name	Type	Additional information
accountID	integer	Required
workflowItemID	integer	Required
metaValue_ActionFlowGroupID	integer	Required
isAutomatic	boolean	Required

Body Parameters

None.

Response Information

Resource Description

ExecuteSqlVM

Name	Type	Additional information
AccountID	integer	None.
WorkflowLineID	integer	None.
Description	string	None.
SQL	string	None.

Response Formats

application/json, text/json

Sample:

{
  "AccountID": 1,
  "WorkflowLineID": 1,
  "Description": "sample string 1",
  "SQL": "sample string 2"
}

application/xml, text/xml

Sample:

<ExecuteSqlVM xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Debtrak.BusinessObjects.ViewModels.WorkflowAction">
  <AccountID>1</AccountID>
  <Description>sample string 1</Description>
  <SQL>sample string 2</SQL>
  <WorkflowLineID>1</WorkflowLineID>
</ExecuteSqlVM>