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/ |
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.
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.
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.
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.
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))))}"
}
}
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".
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.
Now, when you create a record of the specified entity type, the trigger activates.
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]
- 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 valueField (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 referenceField (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
- From existing record in your flow, you can use
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 |
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 |
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 |
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 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
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
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Entity name
|
entity | True | string |
Name of the entity |
body
|
body | True | dynamic |
New record |
Returns
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
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 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
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
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
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
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
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
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 |
This is the basic data type 'binary'.