Progressus Advanced Projects (Preview)
Use Progessus Advanced Projects connector to make odata calls to Progresssus Advanced Projects data.
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 | Todd Michael |
| URL | https://www.progressusglobal.com/contact-us/ |
| support@plumblineconsulting.com |
| Connector Metadata | |
|---|---|
| Publisher | Plumbline Consulting |
| Website | https://www.progressusglobal.com/ |
| Privacy policy | https://www.progressusglobal.com/privacy-policy/ |
| Categories | Business Management;Finance |
Progressus Advanced Projects is a project accounting and project management solution for Microsoft Dynamics 365 Business Central. Use Progressus Advanced Projects connection tool to make OData calls to Progressus Advanced Projects data in PowerAutomate or other tools. These queries make use of OData features such as filtering and selecting of fields in order to retrieve only the records and fields needed.
Prerequisites
Business Central with Progressus Advanced Projects extension installed
How to get credentials
Generate a Web Service access key for a User in Business Central:
Get started with your connector
The connector’s fields are used in the following manner to form a Business Central web service URL:
https://api.businesscentral.dynamics.com/<API Version>/<Tenant ID>/<Environment Name>/api/progressus/<API Name>/<API Version 2>/companies(<Company ID>)/<Plural API Name>
Known issues and limitations
This connector is intended for use with Progressus Advanced Projects. The dropdown of API names is restricted to tables related to Progressus Advanced Projects. To attempt to query non-listed tables, you may use the ‘Enter Custom Value’ option.
Common errors and remedies
Most errors are likely to be caused by not having the correct syntax for the $filter, $select, and $orderby fields. Make sure to check that proper Odata syntax is used for these field.
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 |
|---|---|---|---|
| Username | securestring | The Username for this api | True |
| Web Service Access Key | securestring | The Web Service Access Key for this api | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Get Records |
Retrieve records |
Get Records
Retrieve records
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
API Version
|
API Version | True | string |
Dynamics 365 Business Central API version |
|
Tenant ID
|
Tenant ID | True | string |
Tenant ID for Dynamics 365 Business Central |
|
Environment Name
|
Environment Name | True | string |
Name of the Dynamics 365 Business Central environment |
|
API Name
|
API Name | True | string |
Name of the Dynamics 365 Business Central API category |
|
API Version 2
|
API Version 2 | True | string |
API version number of the specified API name |
|
Company ID
|
Company ID | True | string |
GUID of the Dynamics 365 Business Central company |
|
Plural API Name
|
Plural API Name | True | string |
Name of the Dynamics 365 Business Central table |
|
$filter
|
$filter | string |
Optional OData filter parameter |
|
|
$select
|
$select | string |
Optional OData select parameter |
|
|
$orderby
|
$orderby | string |
Optional OData orderby parameter |