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

Operation ID:

GetQueryExecutionById

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

Body

QueryExecutionResults

Groups Search

Operation ID:

GroupsSearch

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

Operation ID:

WorkflowExecutions

Workflow Executions

Parameters

Name	Key	Required	Type	Description
id	id		string	ID of the workflow to execute

Returns

Body

WorkflowExecutions

Workflow Executions Search

Operation ID:

WorkflowExecutionsSearch

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

Body

WorkflowExecutionsSearch

Workflows Search

Operation ID:

WorkflowsSearch

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