Resco Cloud

Resco Cloud is an all-in-one business solution that is highly customizable, secure, feature-rich and 100% offline-ready.

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/resco-cloud/
Privacy policy https://www.resco.net/privacy-notice/
Categories Sales and CRM;Productivity

Resco Cloud provides you with all-in-one business solutions that are highly customizable, secure, feature-rich, and 100% offline-ready. This connector enables operations that allow you to seamlessly create, read, update, and delete records.

Prerequisites

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

  • An organization at Resco Cloud or any affiliated product from Resco.
  • You can sign up for a free 30-day trial here.
  • A user account with schema access privilege or system administrator privilege.

How to get credentials

This connector uses Basic authentication. When creating a new connector (in Power Apps/Logic Apps), you'll be required to provide login credentials. You will be also required to select a server to use with this connector and the organization name you specified during sign up.

Getting started with connector

Simply add any Resco Cloud connector step to your flow and start accessing/changing data in your Resco Cloud organization. This connector allows you to perform basic data operations such as read/create/update/delete.

Known issues and limitations

Paging

The List records action returns a maximum of 1000 records. If you would like to get more records, you have to use the Skip token input parameter. The Skip token is not returned directly, but instead Next Link is returned which contains Skip token also. To resolve Skip token for the next List records action call, you can use the expression in Set variable step like:

{
    "inputs": {
        "name": "skipToken",
        "value": "@{if(empty(outputs('List_records')?['body/@odata.nextLink']),null,decodeUriComponent(substring(outputs('List_records')?['body/@odata.nextLink'],add(indexOf(outputs('List_records')?['body/@odata.nextLink'], '$skipToken='),11))))}"
    }
}
Triggers

Resco Cloud connector supports triggers for create, update, and delete operations. In case of advanced requirements, there is a workaround available using the server process event and invoking an HTTP request provided by "When an HTTP request is received". Simply create a new automated cloud flow, name it, and click skip to create an empty flow. Search for "Request" connector and add the "When an HTTP request is received" trigger. Set "Request Body JSON Schema" to accept the id parameter:

 {
    "type": "object",
    "properties": {
        "id": {
            "type": "string"
        }
    }
}

Under "Show Advanced Options" set method to POST. Save the flow to generate "HTTP POST URL". App Flow

Now you have to create a process to invoke trigger in your flow. Log into your Resco Cloud server, start the Admin Console, and select Processes from the menu. Click "New", enter a name for the new process, select the desired entity (e.g. Account), and the desired event (e.g. Record is created). Add StringList variable headers and add item Content-Type: application/json;charset=utf-8 to it. Add string variable body as "Format Text" with:

\{ "id": "{Entity.id}" \}

Then, add the function step Server.InvokeWebRequest with POST method. URL copied from "When an HTTP request is received" trigger and body variable. App Process

Now, when you create a record of the specified entity type, the trigger activates.

Common errors and remedies

For cloud servers, make sure that you have specified the proper server under the Connection dialog. If not, you may get an Unauthorized error. For custom or on-premise servers, enter the URL including protocol and port (if applicable), e.g. https://mycompany.com[:8080]

FAQ

  • Q: How to use List records input parameters? A: These are standard OData query parameters. The syntax for each input parameter is defined by OData specification. The only thing to think of is using logical names instead of display names. (e.g. Account -> account, Name -> name, etc.). Logical names can be found under Entities in the Admin Console.
  • Q: How do I get a picklist label? A: Each picklist field returns 2 values:
    • Field - This is the picklist value
    • Field (Label) - This is the label for the picklist value.
  • Q: How do I get a lookup label? A: Each lookup field returns 3 values:
    • Field - This is the ID (GUID) of the reference
    • Field (Label) - This is the label (primary name) of the reference.
    • Field (Type) - This is the target entity of the reference.
  • Q: How do I set lookup field? A: When setting lookup fields, you have to construct a reference consisting of record type and record id.
    • From existing record in your flow, you can use OData Id
    • By creating logicalName:id expression
    • By creating logicalName('id') expression

Creating a connection

The connector supports the following authentication types:

Cloud Server Use a cloud server to access your organization. All regions Not shareable
On-premise Server Use an on-premise server to access your organization. All regions Not shareable
Default [DEPRECATED] This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility. All regions Not shareable

Cloud Server

Auth ID: cloudServer

Applicable: All regions

Use a cloud server to access your organization.

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
Resco Server string True
Organization string True
Username securestring True
Password securestring True

On-premise Server

Auth ID: onPremiseServer

Applicable: All regions

Use an on-premise server to access your organization.

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
Resco Server string True
Organization string True
Username securestring True
Password securestring True

Default [DEPRECATED]

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

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
Resco Server string True
Organization string True
Username securestring True
Password securestring True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Create a new record

Create a new record

Delete record

Delete record by ID

Generate report

Generate report

Get current user

Get current user record by ID

Get questionnaire

Get of questionaire record by ID

Get record

Get record by ID

List questionnaires

Get list of questionnaire records

List records

Get list of records

Update a record

Update record by ID

Create a new record

Create a new record

Parameters

Name Key Required Type Description
Entity name
entity True string

Name of the entity

body
body True dynamic

New record

Returns

The outputs of this operation are dynamic.

Delete record

Delete record by ID

Parameters

Name Key Required Type Description
Record ID
id True string

Enter a globally unique identifier (GUID)

ETag
If-Match string

ETag (entity version)

Entity name
entity True string

Name of the entity

Generate report

Generate report

Parameters

Name Key Required Type Description
Entity name
entity True string

Name of the entity

Record ID
id True string

Enter a globally unique identifier (GUID)

Report Name
report True string

Name of the report

Format
extension True string

Format of file

Returns

Report content
binary

Get current user

Get current user record by ID

Parameters

Name Key Required Type Description
Select query
$select string

Limit the properties returned while retrieving data

Expand query
$expand string

Related records to include with requested records (default = none)

Returns

The outputs of this operation are dynamic.

Get questionnaire

Get of questionaire record by ID

Parameters

Name Key Required Type Description
Record ID
id True string

Enter a globally unique identifier (GUID)

Select query
$select string

Limit the properties returned while retrieving data

Questionaire name
questionnaire True string

Name of the questionaire

Returns

The outputs of this operation are dynamic.

Get record

Get record by ID

Parameters

Name Key Required Type Description
Record ID
id True string

Enter a globally unique identifier (GUID)

Select query
$select string

Limit the properties returned while retrieving data

Expand query
$expand string

Related records to include with requested records (default = none)

Entity name
entity True string

Name of the entity

Returns

The outputs of this operation are dynamic.

List questionnaires

Get list of questionnaire records

Parameters

Name Key Required Type Description
Select query
$select string

Limit the properties returned while retrieving data

Filter query
$filter string

An ODATA filter query to restrict the records returned

Top Count
$top integer

Total number of records to retrieve

Skip count
$skip integer

Skip the first n records

Skip token
$skiptoken string

The token for accessing the next page of records

Questionaire name
questionnaire True string

Name of the questionaire

Returns

The outputs of this operation are dynamic.

List records

Get list of records

Parameters

Name Key Required Type Description
Select query
$select string

Limit the properties returned while retrieving data

Filter query
$filter string

An ODATA filter query to restrict the records returned

Order by
$orderby string

An ODATA orderBy query for specifying the order of records

Expand query
$expand string

Related records to include with requested records (default = none)

Top Count
$top integer

Total number of records to retrieve

Skip count
$skip integer

Skip the first n records

Skip token
$skiptoken string

The token for accessing the next page of records

Entity name
entity True string

Name of the entity

Returns

The outputs of this operation are dynamic.

Update a record

Update record by ID

Parameters

Name Key Required Type Description
Record ID
id True string

Enter a globally unique identifier (GUID)

ETag
If-Match string

ETag (entity version)

Entity name
entity True string

Name of the entity

body
body True dynamic

New property values

Returns

The outputs of this operation are dynamic.

Triggers

When an item is created-updated-deleted

When an item is created-updated-deleted

When an item is created-updated-deleted

When an item is created-updated-deleted

Parameters

Name Key Required Type Description
Entity name
$entity True string

Name of the entity

Action name
$action True string

Action

Returns

Name Path Type Description
id
id string

Definitions

binary

This is the basic data type 'binary'.