Share via


Datablend (Preview)

Connect to Datablend for a cost-effective iPaaS solution supporting finance and accounting

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Datablend Support
URL https://datablend.com/contact
Email support@datablend.com
Connector Metadata
Publisher DataBlend
Website https://datablend.com
Privacy Policy https://datablend.com/privacy-policy/
Categories Finance;Productivity

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Get Query Execution by ID

Get Query Execution by ID

Groups Search

Groups Search

Workflow Executions

Workflow Executions

Workflow Executions Search

Workflow Executions Search

Workflows Search

Workflows Search

Get Query Execution by ID

Get Query Execution by ID

Parameters

Name Key Required Type Description
The ID of the query execution used when running a workflow.
id True string

Get Query Execution by ID

Returns

Groups Search

Parameters

Name Key Required Type Description
offset
offset integer

offset

limit
limit integer

limit

path
path string

path

direction
direction string

sort direction

Returns

Workflow Executions

Workflow Executions

Parameters

Name Key Required Type Description
id
id string

ID of the workflow to execute

Returns

Workflow Executions Search

Parameters

Name Key Required Type Description
limit
limit integer

limit

offset
offset integer

offset

path
path string

path

direction
direction string

direction

path
path string

path

value
value string

id of the workflow previously executed

comparator
comparator string

comparator

Returns

Workflows Search

Parameters

Name Key Required Type Description
offset
offset integer

offset

path
path string

path

direction
direction string

direction

path
path string

path

value
value string

ID of the group you wish to find workflows in.

comparator
comparator string

comparator

Returns

Definitions

WorkflowsSearch

Name Path Type Description
predicate
predicate Predicate
offset
offset integer

Starting Array Number

limit
limit integer

Number of results to show

orders
orders array of Orders

Sort Order

totalResults
totalResults integer

Total results

results
results array of WorkflowSearchResults

Results

WorkflowSearchResults

Name Path Type Description
schedule
schedule string

Schedule

isPaused
isPaused boolean

Is Paused

parameters
parameters array of Parameters

Parameters

name
name string

Workflow Name

ownableType
ownableType string

Ownable Type

created
created date-time

Created

updated
updated date-time

Updated

createdBy
createdBy CreateUpdateBy
updatedBy
updatedBy CreateUpdateBy
group
group Groups
id
id string

Workflow Search Id

WorkflowExecutions

Name Path Type Description
steps
steps array of Steps

Workflow steps

parameters
parameters array of Parameters

Workflow parameters

parent
parent Parent
created
created date-time

Results Created

updated
updated date-time

Results Updated

started
started date-time

Results Started

completed
completed date-time

Results Completed

state
state string

Result State

statusMessage
statusMessage string

Status Message

createdBy
createdBy CreateUpdateBy
updatedBy
updatedBy CreateUpdateBy
cancelBy
cancelBy CreateUpdateBy
jobId
jobId string

Job ID

scheduled
scheduled boolean

Scheduled

hasWarnings
hasWarnings boolean

Has Warnings

timeout
timeout integer

Timeout

id
id string

Workflow Execution Query Result ID

WorkflowExecutionsSearch

Name Path Type Description
predicate
predicate Predicate
offset
offset integer

Starting Array Number

limit
limit integer

Number of results to show

orders
orders array of Orders

Sort Order

totalResults
totalResults integer

Total results

results
results array of WorkflowExecutionsSearchResults

Results

WorkflowExecutionsSearchResults

Workflow Execution Query Results

Name Path Type Description
steps
steps array of Steps

Workflow steps

parameters
parameters array of Parameters

Workflow parameters

parent
parent Parent
created
created date-time

Results Created

updated
updated date-time

Results Updated

started
started date-time

Results Started

completed
completed date-time

Results Completed

state
state string

Result State

statusMessage
statusMessage string

Status Message

createdBy
createdBy CreateUpdateBy
updatedBy
updatedBy CreateUpdateBy
cancelBy
cancelBy CreateUpdateBy
jobId
jobId string

Job ID

scheduled
scheduled boolean

Scheduled

hasWarnings
hasWarnings boolean

Has Warnings

timeout
timeout integer

Timeout

id
id string

Workflow Execution Query Result ID

Parent

Name Path Type Description
schedule
schedule string

Schedule

isPaused
isPaused boolean

Is Paused

parameters
parameters array of Parameters

Parameters

name
name string

Name

ownableType
ownableType string

Credential

created
created date-time

Created

updated
updated date-time

Updated

createdBy
createdBy CreateUpdateBy
updatedBy
updatedBy CreateUpdateBy
group
group Groups
id
id string

Parent ID

CreateUpdateBy

Name Path Type Description
created
created date-time

Created

name
profile.name string

Profile Name

id
profile.id string

Profile Id

id
id string

Created by ID

Steps

Name Path Type Description
started
started date-time

DateTime workflow step started

completed
completed date-time

DateTime workflow step completed

state
state string

State of workflow step

name
name string

Name of workflow step

taskId
taskId string

Task ID of workflow step

statusMessage
statusMessage string

Status Message

outputs
outputs Outputs
hasWarnings
hasWarnings boolean

Has warnings

continueOnError
continueOnError boolean

Can continue on error

Outputs

Name Path Type Description
additionalProp1
additionalProp1 string

Additional Property 1

additionalProp2
additionalProp2 string

Additional Property 2

additionalProp3
additionalProp3 string

Additional Property 3

Groups

Name Path Type Description
name
name string

Group Name

created
created date-time

Group Create DateTime

currentRole
currentRole string

Current Role

historyRetentionDays
historyRetentionDays integer

Days to retain data

fiscalYearStartMonth
fiscalYearStartMonth integer

Fiscal Year start month

externalId
externalId string

External ID

id
id string

Group Id

Parameters

Name Path Type Description
type
type string

Replace

valueType
valueType string

Value Type

enumType
enumType string

Enum type

name
name string

Name

value
value string

Value

path
path object
dateFormat
dateFormat string

Date Format

calculatedValue
calculatedValue string

Calculated Value

GroupSearch

Name Path Type Description
predicate
predicate Predicate
offset
offset integer

Starting Array Number

limit
limit integer

Number of results to show

orders
orders array of Orders

Sort Order

totalResults
totalResults integer

Total results

results
results array of GroupSearchResults

Results

QueryExecutionResults

Name Path Type Description
queryExecutionId
queryExecutionId string

Id of the executed query

nextToken
nextToken string

Next Token

columns
columns array of QueryExecutionResultsColumns

Columns

rows
rows object

Rows

QueryExecutionResultsColumns

Name Path Type Description
name
name string

Name

type
type string

Type

Predicate

Name Path Type Description
id
id string

ID

Orders

Name Path Type Description
path
path string

Property path

direction
direction string

Ascending or Descending sort

GroupSearchResults

Name Path Type Description
name
name string

Name

created
created string

DateTime string

currentRole
currentRole string

Role

historyRetentionDays
historyRetentionDays integer

Days to retain data

fiscalYearStartMonth
fiscalYearStartMonth integer

Fiscal Year start month

externalId
externalId string

External Id string

id
id string

GUID string