Resco Reports

Resco Reports provides you with a highly customizable tool for generating reports and documents based on your Dataverse / Dynamics data. This connector makes it possible to use the Resco Mobile Report templates to automate document generation or any other back-office scenarios.

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	Resco experts are ready to listen and help
URL	https://www.resco.net/contact-support/
Email	mobilecrm@resco.net

Connector Metadata
Publisher	Resco
Website	https://www.resco.net/platform/
Privacy policy	https://www.resco.net/privacy-notice/
Categories	Sales and CRM;Productivity

Resco Reports provides you with a highly customizable tool for generating reports and documents based on your Dataverse / Dynamics data. This connector makes it possible to use the Resco Mobile Report templates to automate document generation or any other back-office scenarios.

Prerequisites

In order to use this connector, you will need the following:

• Dataverse / Dynamics organization with Woodford solution (available here).
• A user account with schema access privilege or system administrator privilege.
• Some reports created with Resco Report Designer

How to get credentials

This connector uses OAuth2 authentication. When creating a new connection, you'll be required to specify your Dataverse environment (its resource URI) and give the consent for Resco Reports Azure app to access your data. The connector will then use this connection to fetch the report definitions and all data necessary to generate the report document.

Getting started

This connector can follow many flow triggers. The most frequent scenarios are:

• When a row is selected (Dataverse) trigger, which allows to run it from Power Apps form via Flow command.
• When an HTTP request is received trigger, which can be used to run a flow from JavaScript button handler.
• PowerApps trigger, which allows to run a flow for manually entered arguments.

The output of this connector is a Report content which can be consumed as an input for various actions like filling the email attachment content, Note record document body or SharePoint document body. Report content output is supplemented by File name and Content type headers. In the case of HTTP request trigger, it can be used directly as a response.

Known Issues and Limitations

• Report is generated in the context of a certain table (let's say Accounts), and only a subset of report templates are relevant (those targeting Accounts table). Despite that, the connector offers all available report templates when choosing argument Report id or Name.

Common errors and remedies

The error is mostly caused by wrong arguments passed to the connector action. In such a case, the connector returns HTTP error 400 (Bad request) and the response body contains JSON data with an error message and additional data. The error message should explain which parameter had an unexpected format or value.

In case of unexpected errors, the connector returns HTTP error 500 (Internal server error), and the response body contains JSON data with an error message and aditional data. Please report such case to the support service.

FAQ

Q: How can I run a specific report from entity form? A: Define a new flow in Power Automate, specify trigger When a row is selected (Dataverse), add Resco Reports step, and choose Generate a single row report. Specify your Dataverse environment, choose your report name from the list as reportId argument, choose the report file format and use Dynamic content to choose your entity primary key field as sourceId argument. Finally, specify an action consuming resulting Report content and File name variables that will appear in Dynamic content for any step following the Resco Reports action.

Q: How can I generate a report for a set of records selected in the list? A: You can create a custom button with a Javascript function taking the list of currently selected records and posting an HTTP request to Power Automate flow with When an HTTP request is received trigger. This trigger can then take your custom arguments and pass them to Resco Reports action Generate a report on multiple rows.

Creating a connection

The connector supports the following authentication types:

Default	Parameters for creating connection.	All regions	Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
Dataverse resource URL	string	Dataverse resource URL	True

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	100	60 seconds

Actions

Generate a report on multiple rows	Generates a report for provided list of table rows.
Generate a report on multiple rows (fetch XML)	Generates a report for a set of table rows defined by fetch XML query.
Generate a Resco questionnaire report	Generates a report or an auto-report for specific Resco questionnaire.
Generate a single row report	Generates a report for specific table row.

Generate a report on multiple rows

Operation ID:

GenMultiReport

Generates a report for provided list of table rows.

Parameters

Name	Key	Required	Type	Description
Report id or Name	reportid	True	string	Mobile report id or name
Comma-delimited list of record IDs	sources	True	string	Comma-delimited list of record IDs
Format	format		string	Report file format. Default is PDF.

Generate a report on multiple rows (fetch XML)

Operation ID:

GenFetchReport

Generates a report for a set of table rows defined by fetch XML query.

Parameters

Name	Key	Required	Type	Description
Report id or Name	reportid	True	string	Mobile report id or name
Fetch XML request defining source entities	sourcefetch	True	string	Fetch XML request defining source entities
Format	format		string	Report file format. Default is PDF.

Generate a Resco questionnaire report

Operation ID:

GenQuestionnaireReport

Generates a report or an auto-report for specific Resco questionnaire.

Parameters

Name	Key	Required	Type	Description
Source questionnaire entity id	questionnaireid	True	string	Source questionnaire entity id
Report id or Name	reportid		string	Mobile report id or name
Format	format		string	Report file format. Default is PDF.

Generate a single row report

Operation ID:

GenEntityReport

Generates a report for specific table row.

Parameters

Name	Key	Required	Type	Description
Report id or Name	reportid	True	string	Mobile report id or name
Source entity id	sourceid	True	string	Source entity id
Format	format		string	Report file format. Default is PDF.