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 protected] |
| 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
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
- Body
- GroupSearch
Workflow Executions
Workflow Executions
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
id
|
id | string |
ID of the workflow to execute |
Returns
- Body
- WorkflowExecutions
Workflow Executions Search
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
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
- Body
- WorkflowsSearch
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 |