1

Resco Reports connector

From Resco's Wiki
Jump to navigation Jump to search
Integration with third-party systems

Resco CRM Connector (web APIs):




Traditionally, Resco's mobile reports are generated directly in Resco mobile apps. In some use cases, back office workers who don't have access to Resco Mobile CRM also want to generate such reports.

Resco Reports connector is a tool that allows you to generate reports directly from Dataverse/Dynamics backend using Power Automate flow. It is compatible with Microsoft Power Automate, Microsoft Power Apps, and Azure Logic Apps.

Just like when used in Resco mobile apps, the report templates are created using Resco's Report Designer (or, in the case of questionnaires, in the Questionnaire Designer).

Prerequisites

  • The setup is done only by the admin
  • Report Template created in the organization
  • Power Automate license for an admin
  • Resco license
  • Dataverse Admin License

Setup

Tip To see the connector in action, check Resco Docs+.

Flow setup

In this example, we create a flow for a single account report.

  1. Go to the form of the record you want to build a flow for. Click on the hamburger menu.
    Resco Reports connector: flow setup 1
  2. Go to the Flow and select Create a flow.
    Resco Reports connector: flow setup 2
  3. Click Continue.
    Resco Reports connector: flow setup 3
  4. Click Next Step, search for Resco Reports, and select it.
    Resco Reports connector: flow setup 4
  5. Select Generate a single row report.
    Resco Reports connector: flow setup 5
  6. Select the correct Report id or Name, Source entity id (in this case, Account), and your preferred format.
    Resco Reports connector: flow setup 6

Report setup examples:

In previous section, we created a flow to generate the Resco Report via Power Automate. The next step is to set up what will happen with this report. There are multiple options for report setup. Here are some examples:

Send an email action/step:

  1. Choose "Send an email" as the next step:
    Resco Reports connector: Send Report In Email 1

Save the report as a Note related to the account:

  1. Choose "Add a new row" as the next step:
    Resco Reports connector: Send Report In Email 2: Add a new row
  2. For a Table name select "Notes" and for Is Document select "Yes". The title can be defined as follows:
    Resco Reports connector: Send Report In Email 3: Add a new row details
  3. Click on "Show advanced options" and start filling Document (follow the gif bellow).
  4. Select Expression and type in "base64()".
  5. Click on Dynamic content and set your cursor in between brackets of "base64(|)". Click on "Report content" for the options listed below and click "OK".
    Resco Reports connector: Send Report In Email 4: Add New Row Document
  6. For Mime type enter "application/pdf".
  7. For Regarding (table you create the report on), in this case account, add:
    Resco Reports connector: Send Report In Email 5: Regarding Accounts

If you decided to go with the Save the report as Note example, the entire flow should look like this:
Resco Reports connector: Save report as note

Run the report

After completing all previous steps, the Report flow will be available on the form.

Resco Reports connector: Report flow will be available on the form

Known issues and limitations

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

Static images

Static images (such as logos), fonts, or other documents stored in the offline HTML section of Woodford project are not available while generating the report on Dynamics. Therefore, these features are not supported. In the case of company logos, consider saving the logo in Dynamics, for example, as a note of a related entity.

SharePoint images

Resco Reports connector's scope does not include SharePoint. As a result, you may not include images from SharePoint in your reports.

Common errors and remedies

The error is mainly 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 additional data. Please report such cases to the support service.

FAQ

How can I run a specific report from the entity form?
Define a new flow in Power Automate, specify trigger When a row is selected (Dataverse), add the Resco Reports step, 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 appearing in Dynamic content for any step following the Resco Reports action.
How can I generate a report for a set of records selected in the list?
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 the 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.
What happens to my data?
The Microsoft Azure server used to create reports is based in EU. Data (encrypted via OAuth token) are sent to the server, the report is created, and the data are deleted. Thus, data are not stored anywhere. They are deleted immediately after the processing.

See also




Was this information helpful? How can we improve?