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/
Email 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:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services-authentication#generate-a-web-service-access-key

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>

Connector-1

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.

Connector-2

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 connection10060 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

Returns