Blackbaud FENXT Query (Preview)
Blackbaud Financial Edge NXT is a comprehensive cloud-based accounting software solution built specifically for nonprofits. Use the Query connector to manage and execute queries.
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 | Blackbaud Support |
| URL | https://www.blackbaud.com/support |
| skyapi@blackbaud.com |
| Connector Metadata | |
|---|---|
| Publisher | Blackbaud. Inc |
| Website | https://www.blackbaud.com/products/blackbaud-financial-edge-nxt |
| Privacy policy | https://www.blackbaud.com/privacy-shield |
| Categories | Sales and CRM;Productivity |
Financial Edge NXT is a total cloud accounting solution designed specifically to meet the unique needs of nonprofits and government entities.
This connector is built on top of Blackbaud's SKY API, and provides operations to help manage queries and related entities found within Financial Edge NXT.
For more information, please view the documentation.
Prerequisites
To use this connector, you must have a Blackbaud ID account with access to one or more Blackbaud environments.
In addition, the Microsoft Power Platform application from the Blackbaud Marketplace must be connected to the environment. More information about these prerequisites can be found in the initial setup documentation.
How to get credentials?
Your organization's administrator will send you an invitation to the organization's Financial Edge NXT environment and configure your user account permissions within the environment. No additional credentials are required to use this connector.
Known issues and limitations
The connector will operate in the context of your user account, and will therefore be subject to your user permissions within the environment.
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Get query job status |
Returns information about a background query execution job. |
| List queries |
Returns a list of queries. |
| Start a query job |
Starts a background job to execute the specified query. |
| Start a refresh static query job |
Starts a background job to refresh the saved keys for the specified static query. |
| Start an ad hoc query job |
Starts a background job to execute the specified ad hoc query definition. |
Get query job status
Returns information about a background query execution job.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Module
|
module | True | string |
The Financial Edge NXT module for the request. |
|
Job ID
|
job_id | True | string |
The system record ID of the query execution job. |
|
Include results URL?
|
include_read_url | string |
Include the URL to the query results file? |
|
|
Content disposition
|
content_disposition | string |
Indicates how the query results will be viewed. |
Returns
Query execution job
List queries
Returns a list of queries.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Module
|
module | True | string |
The Financial Edge NXT module for the request. |
|
Type
|
query_type_id | integer |
Filter the set of queries to those with a specific query type. |
|
|
Category
|
category | integer |
Filter the set of queries to those with a specific category. |
|
|
Format
|
query_format | string |
Filter the set of queries to those with a specific format. |
|
|
Search text
|
search_text | string |
The name field search text to filter the results. |
|
|
My queries only?
|
my_queries_only | boolean |
Include only queries I created? |
|
|
Merged queries only?
|
merged_queries_only | boolean |
Include only merged queries? |
|
|
Sort column
|
sort_column | string |
Sort the results by the specified column. |
|
|
Sort descending?
|
sort_descending | boolean |
Sort the results in descending order? |
|
|
Limit
|
limit | integer |
Represents the number of records to return. The default is 50. The maximum is 500. |
|
|
Offset
|
offset | integer |
Represents the number of records to skip. For use with pagination. |
Returns
Queries
Start a query job
Starts a background job to execute the specified query.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Module
|
module | True | string |
The Financial Edge NXT module for the request. |
|
Type
|
v_query_type_id | True | integer |
Filter the set of queries to those with a specific query type. |
|
Query
|
id | True | integer |
The query to execute. |
|
Output format
|
output_format | string |
Indicates the output format for the query results file. |
|
|
Formatting mode
|
formatting_mode | string |
Indicates whether and how formatting should be applied to the query results. |
|
|
SQL generation mode
|
sql_generation_mode | string |
Indicates how query select fields should be handled. When 'Query' is selected, the output will include the select fields defined for the query plus QRECID. When 'Export' is selected, the output will include the select fields defined for the query ONLY. When 'Report' is selected, the output will ONLY include QRECID. |
|
|
Use static query?
|
use_static_query_id_set | boolean |
Use the static query as the source of records (if not, the query will be executed dynamically)? |
Returns
Started query job
Start a refresh static query job
Starts a background job to refresh the saved keys for the specified static query.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Module
|
module | True | string |
The Financial Edge NXT module for the request. |
|
Type
|
v_query_type_id | True | integer |
Filter the set of queries to those with a specific query type. |
|
Query
|
id | True | integer |
The query to execute. |
Returns
Started query job
Start an ad hoc query job
Starts a background job to execute the specified ad hoc query definition.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Module
|
module | True | string |
The Financial Edge NXT module for the request. |
|
Query definition
|
query | True | object |
The JSON representation of the query definition. |
|
Output format
|
output_format | string |
Indicates the output format for the query results file. |
|
|
Formatting mode
|
formatting_mode | string |
Indicates whether and how formatting should be applied to the query results. |
Returns
Started query job
Definitions
QueryApi.ExecuteQueryResponse
Started query job
| Name | Path | Type | Description |
|---|---|---|---|
|
Job ID
|
id | string |
The query job identifier. |
|
Status
|
status | string |
The resulting query job status. 'Pending' - the job has been queued but has not yet started running. 'Running' - the job is running. 'Completed' - the job completed successfully. 'Failed' - the job failed. 'Cancelling' - job cancellation has been requested (but may still complete successfully). 'Cancelled' - the job was canceled. 'Throttled' - the job has been throttled and will run when space is available. |
|
Message
|
message | string |
A message associated with the response. |
QueryApi.QueryExecutionJob
Query execution job
| Name | Path | Type | Description |
|---|---|---|---|
|
Job ID
|
id | string |
The query job identifier. |
|
Status
|
status | string |
The resulting query job status. 'Pending' - the job has been queued but has not yet started running. 'Running' - the job is running. 'Completed' - the job completed successfully. 'Failed' - the job failed. 'Cancelling' - job cancellation has been requested (but may still complete successfully). 'Cancelled' - the job was canceled. 'Throttled' - the job has been throttled and will run when space is available. |
|
Row count
|
row_count | integer |
The number of records in the query. |
|
Query results URI
|
sas_uri | string |
The URI for accessing the query results. This URI should be treated as a secure credential to access the query results - the value is considered sensitive, and the URI will expire after 15 minutes. |
QueryApi.QuerySummary
Query
| Name | Path | Type | Description |
|---|---|---|---|
|
ID
|
id | integer |
The system record ID of the query. |
|
Name
|
name | string |
The unique name of the query. |
|
Description
|
description | string |
The description of the query. |
|
Type
|
type | string |
The type of the query. |
|
Type ID
|
type_id | integer |
The system record ID of the query type. |
|
Category
|
category | string |
The category of the query. |
|
Category ID
|
category_id | integer |
The system record ID of the query category. |
|
Format
|
format | string |
The query format. |
|
View supported?
|
view_supported | boolean |
Is the query viewable? |
|
Supported execution modes
|
supported_execution_modes | string |
The supported execution modes. |
|
Can modify?
|
can_modify | boolean |
Can the user modify the query? |
|
Can execute?
|
can_execute | boolean |
Can the user execute the query? |
|
Others can modify?
|
others_can_modify | boolean |
Can other users modify the query? |
|
Others can execute?
|
others_can_execute | boolean |
Can other users execute the query? |
|
Suppress duplicates?
|
suppress_duplicates | boolean |
Are duplicates suppressed in the query results? |
|
Select from query name
|
select_from_query_name | string |
The name of the query used as the base select for the query. |
|
Select from query ID
|
select_from_query_id | integer |
The system record ID of the query used as the base select for the query. |
|
Last run
|
date_last_run | date-time |
The date when the query was last run. |
|
Number of records
|
num_records | integer |
The number of records found the last time the query was run. |
|
Elapsed time
|
elapsed_ms | integer |
The elapsed time (in milliseconds) the last time the query was run. |
|
Date created
|
date_added | date-time |
The date when the query was created. |
|
Created by
|
added_by | string |
The name of the user that created the query. |
|
Date changed
|
date_changed | date-time |
The date when the query was last changed. |
|
Changed by
|
last_changed_by | string |
The name of the user that last changed the query. |
QueryApi.QuerySummaryCollection
Queries
| Name | Path | Type | Description |
|---|---|---|---|
|
queries
|
queries | array of QueryApi.QuerySummary |
The set of items included in the response. |