Working days (Independent Publisher) (Preview)
Working days service. It covers more than 45 countries and 230 regional calendars. It also covers main stock exchanges calendars. The quality of data is the top priority. API offers up to date information by following government announcements regarding public holidays changes.
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 | Tomasz Poszytek |
| URL | https://aka.ms/poszytek |
| [email protected] |
| Connector Metadata | |
|---|---|
| Publisher | Tomasz Poszytek |
| Website | https://api.workingdays.org/ |
| Privacy policy | https://api.workingdays.org/1.2/privacy_policy.php |
| Categories | Finance;Commerce |
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 |
|---|---|---|---|
| Provide your API key. | securestring | Provide your API key. | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Add public holidays |
Add days where public holidays are taking place to a given date. |
| Add weekend days |
Add weekends days to a given date. |
| Add working days |
Add (or remove) any number of working days to a date. |
| Add working hours |
Add an amount of working time to a given start date/time. |
| Analyze |
Analyze a period (provide a start_date and an end_date over a given calendar, API responds with the period analysis). |
| Check quota |
Check quota of left days to use within the current month and available for the next month. |
| Get day information |
Get detailed information about a specific day. |
| List non working days |
List the non working days (weekend days, public holidays and custom dates) between 2 dates. |
| Locating a postal address |
Sometimes it may be needed to identify which calendar configuration is relevant to a given customer's postal address. This service returns the appropriate country_code & configuration for a given postal adresss. |
Add public holidays
Add days where public holidays are taking place to a given date.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Start date
|
start_date | True | string |
The start date (YYYY-MM-DD) |
|
Increment
|
increment | True | string |
The number of days being public holidays you want to add to your start date (positive or negative integer but not zero). |
|
Include start
|
include_start | True | boolean |
Should the count include the start_date? Default value is true. |
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Week times
|
week_times | string |
Your week working schedule structure. This parameter is useful when computing work hours over a period. When used, this parameter overides the week_hours parameter. |
|
|
Start template
|
start_template | string |
The start date of an alternating week template (YYYY-MM-DD) If you define an alternating week template schedule, you have to tell which sunday the template is starting. |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
end_date
|
result.end_date | string |
End date |
|
All total
|
result.days.total | string |
Total days within the period |
|
All Mondays
|
result.days.mondays | string |
Mondays within the period |
|
All Tuesdays
|
result.days.tuesdays | string |
Tuesdays within the period |
|
All Wednesdays
|
result.days.wednesdays | string |
Wednesdays within the period |
|
All Thursdays
|
result.days.thursdays | string |
Thursdays within the period |
|
All Fridays
|
result.days.fridays | string |
Fridays within the period |
|
All Saturdays
|
result.days.saturdays | string |
Saturdays within the period |
|
All Sundays
|
result.days.sundays | string |
Sundays within the period |
|
All hours
|
result.days.hours | string |
Hours within the period |
|
All working total
|
result.working_days.total | string |
Total working days within the period |
|
All working Mondays
|
result.working_days.mondays | string |
Working Mondays within the period |
|
All working Tuesdays
|
result.working_days.tuesdays | string |
Working Tuesdays within the period |
|
All working Wednesdays
|
result.working_days.wednesdays | string |
Working Wednesdays within the period |
|
All working Thursdays
|
result.working_days.thursdays | string |
Working Thursdays within the period |
|
All working Fridays
|
result.working_days.fridays | string |
Working Fridays within the period |
|
All working Saturdays
|
result.working_days.saturdays | string |
Working Saturdays within the period |
|
All working Sundays
|
result.working_days.sundays | string |
Working Sundays within the period |
|
All working hours
|
result.working_days.work_hours | string |
Working hours within the period |
|
All wages
|
result.working_days.wages | string |
Wages within the period |
|
Total weekend days
|
result.weekend_days.total | string |
Total weekend days within the period |
|
All weekend days on Mondays
|
result.weekend_days.mondays | string |
Weekend days taking place on Mondays within the period |
|
All weekend days on Tuesdays
|
result.weekend_days.tuesdays | string |
Weekend days taking place on Tuesdays within the period |
|
All weekend days on Wednesdays
|
result.weekend_days.wednesdays | string |
Weekend days taking place on Wednesdays within the period |
|
All weekend days on Thursdays
|
result.weekend_days.thursdays | string |
Weekend days taking place on Thursdays within the period |
|
All weekend days on Fridays
|
result.weekend_days.fridays | string |
Weekend days taking place on Fridays within the period |
|
All weekend days on Saturdays
|
result.weekend_days.saturdays | string |
Weekend days taking place on Saturdays within the period |
|
All weekend days on Sundays
|
result.weekend_days.sundays | string |
Weekend days taking place on Sundays within the period |
|
Public holidays
|
result.public_holidays | object |
List of public holidays |
Add weekend days
Add weekends days to a given date.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Start date
|
start_date | True | string |
The start date (YYYY-MM-DD) |
|
Increment
|
increment | True | string |
The number of weekend days you want to add to your start date (positive or negative integer but not zero). |
|
Include start
|
include_start | True | boolean |
Should the count include the start_date? Default value is true. |
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Week times
|
week_times | string |
Your week working schedule structure. This parameter is useful when computing work hours over a period. When used, this parameter overides the week_hours parameter. |
|
|
Start template
|
start_template | string |
The start date of an alternating week template (YYYY-MM-DD) If you define an alternating week template schedule, you have to tell which sunday the template is starting. |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
end_date
|
result.end_date | string |
End date |
|
All total
|
result.days.total | string |
Total days within the period |
|
All Mondays
|
result.days.mondays | string |
Mondays within the period |
|
All Tuesdays
|
result.days.tuesdays | string |
Tuesdays within the period |
|
All Wednesdays
|
result.days.wednesdays | string |
Wednesdays within the period |
|
All Thursdays
|
result.days.thursdays | string |
Thursdays within the period |
|
All Fridays
|
result.days.fridays | string |
Fridays within the period |
|
All Saturdays
|
result.days.saturdays | string |
Saturdays within the period |
|
All Sundays
|
result.days.sundays | string |
Sundays within the period |
|
All hours
|
result.days.hours | string |
Hours within the period |
|
All working total
|
result.working_days.total | string |
Total working days within the period |
|
All working Mondays
|
result.working_days.mondays | string |
Working Mondays within the period |
|
All working Tuesdays
|
result.working_days.tuesdays | string |
Working Tuesdays within the period |
|
All working Wednesdays
|
result.working_days.wednesdays | string |
Working Wednesdays within the period |
|
All working Thursdays
|
result.working_days.thursdays | string |
Working Thursdays within the period |
|
All working Fridays
|
result.working_days.fridays | string |
Working Fridays within the period |
|
All working Saturdays
|
result.working_days.saturdays | string |
Working Saturdays within the period |
|
All working Sundays
|
result.working_days.sundays | string |
Working Sundays within the period |
|
All working hours
|
result.working_days.work_hours | string |
Working hours within the period |
|
All wages
|
result.working_days.wages | string |
Wages within the period |
|
Total weekend days
|
result.weekend_days.total | string |
Total weekend days within the period |
|
All weekend days on Mondays
|
result.weekend_days.mondays | string |
Weekend days taking place on Mondays within the period |
|
All weekend days on Tuesdays
|
result.weekend_days.tuesdays | string |
Weekend days taking place on Tuesdays within the period |
|
All weekend days on Wednesdays
|
result.weekend_days.wednesdays | string |
Weekend days taking place on Wednesdays within the period |
|
All weekend days on Thursdays
|
result.weekend_days.thursdays | string |
Weekend days taking place on Thursdays within the period |
|
All weekend days on Fridays
|
result.weekend_days.fridays | string |
Weekend days taking place on Fridays within the period |
|
All weekend days on Saturdays
|
result.weekend_days.saturdays | string |
Weekend days taking place on Saturdays within the period |
|
All weekend days on Sundays
|
result.weekend_days.sundays | string |
Weekend days taking place on Sundays within the period |
|
Public holidays
|
result.public_holidays | object |
List of public holidays |
Add working days
Add (or remove) any number of working days to a date.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Start date
|
start_date | True | string |
The start date (YYYY-MM-DD) |
|
Increment
|
increment | True | string |
The number of working days you want to add to your start date (positive or negative integer but not zero). |
|
Include start
|
include_start | True | boolean |
Should the count include the start_date? Default value is true. |
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Week times
|
week_times | string |
Your week working schedule structure. This parameter is useful when computing work hours over a period. When used, this parameter overides the week_hours parameter. |
|
|
Start template
|
start_template | string |
The start date of an alternating week template (YYYY-MM-DD) If you define an alternating week template schedule, you have to tell which sunday the template is starting. |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
end_date
|
result.end_date | string |
End date |
|
All total
|
result.days.total | string |
Total days within the period |
|
All Mondays
|
result.days.mondays | string |
Mondays within the period |
|
All Tuesdays
|
result.days.tuesdays | string |
Tuesdays within the period |
|
All Wednesdays
|
result.days.wednesdays | string |
Wednesdays within the period |
|
All Thursdays
|
result.days.thursdays | string |
Thursdays within the period |
|
All Fridays
|
result.days.fridays | string |
Fridays within the period |
|
All Saturdays
|
result.days.saturdays | string |
Saturdays within the period |
|
All Sundays
|
result.days.sundays | string |
Sundays within the period |
|
All hours
|
result.days.hours | string |
Hours within the period |
|
All working total
|
result.working_days.total | string |
Total working days within the period |
|
All working Mondays
|
result.working_days.mondays | string |
Working Mondays within the period |
|
All working Tuesdays
|
result.working_days.tuesdays | string |
Working Tuesdays within the period |
|
All working Wednesdays
|
result.working_days.wednesdays | string |
Working Wednesdays within the period |
|
All working Thursdays
|
result.working_days.thursdays | string |
Working Thursdays within the period |
|
All working Fridays
|
result.working_days.fridays | string |
Working Fridays within the period |
|
All working Saturdays
|
result.working_days.saturdays | string |
Working Saturdays within the period |
|
All working Sundays
|
result.working_days.sundays | string |
Working Sundays within the period |
|
All working hours
|
result.working_days.work_hours | string |
Working hours within the period |
|
All wages
|
result.working_days.wages | string |
Wages within the period |
|
Total weekend days
|
result.weekend_days.total | string |
Total weekend days within the period |
|
All weekend days on Mondays
|
result.weekend_days.mondays | string |
Weekend days taking place on Mondays within the period |
|
All weekend days on Tuesdays
|
result.weekend_days.tuesdays | string |
Weekend days taking place on Tuesdays within the period |
|
All weekend days on Wednesdays
|
result.weekend_days.wednesdays | string |
Weekend days taking place on Wednesdays within the period |
|
All weekend days on Thursdays
|
result.weekend_days.thursdays | string |
Weekend days taking place on Thursdays within the period |
|
All weekend days on Fridays
|
result.weekend_days.fridays | string |
Weekend days taking place on Fridays within the period |
|
All weekend days on Saturdays
|
result.weekend_days.saturdays | string |
Weekend days taking place on Saturdays within the period |
|
All weekend days on Sundays
|
result.weekend_days.sundays | string |
Weekend days taking place on Sundays within the period |
|
Public holidays
|
result.public_holidays | object |
List of public holidays |
Add working hours
Add an amount of working time to a given start date/time.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Start date
|
start_date | True | string |
The start date (YYYY-MM-DD) |
|
Start time
|
start_time | True | string |
The start time (HH:MM) |
|
Increment time
|
increment_time | True | string |
The amount of working time to be added (or removed) to the start date time. Format: H:i |
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Week times
|
week_times | string |
Your week working schedule structure. This parameter is useful when computing work hours over a period. When used, this parameter overides the week_hours parameter. |
|
|
Start template
|
start_template | string |
The start date of an alternating week template (YYYY-MM-DD) If you define an alternating week template schedule, you have to tell which sunday the template is starting. |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
End date
|
result.end_date | string |
Calculated end date. |
|
End time
|
result.end_time | string |
Calculated end time. |
Analyze
Analyze a period (provide a start_date and an end_date over a given calendar, API responds with the period analysis).
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Start date
|
start_date | True | string |
The start date (YYYY-MM-DD) |
|
End date
|
end_date | True | string |
The end date (YYYY-MM-DD) |
|
Start time
|
start_time | string |
The start time (HH:MM) |
|
|
End time
|
end_time | string |
The end time (HH:MM) |
|
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Week times
|
week_times | string |
Your week working schedule structure. This parameter is useful when computing work hours over a period. When used, this parameter overides the week_hours parameter. |
|
|
Start template
|
start_template | string |
The start date of an alternating week template (YYYY-MM-DD) If you define an alternating week template schedule, you have to tell which sunday the template is starting. |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
end_date
|
result.end_date | string |
End date |
|
All total
|
result.days.total | string |
Total days within the period |
|
All Mondays
|
result.days.mondays | string |
Mondays within the period |
|
All Tuesdays
|
result.days.tuesdays | string |
Tuesdays within the period |
|
All Wednesdays
|
result.days.wednesdays | string |
Wednesdays within the period |
|
All Thursdays
|
result.days.thursdays | string |
Thursdays within the period |
|
All Fridays
|
result.days.fridays | string |
Fridays within the period |
|
All Saturdays
|
result.days.saturdays | string |
Saturdays within the period |
|
All Sundays
|
result.days.sundays | string |
Sundays within the period |
|
All hours
|
result.days.hours | string |
Hours within the period |
|
All working total
|
result.working_days.total | string |
Total working days within the period |
|
All working Mondays
|
result.working_days.mondays | string |
Working Mondays within the period |
|
All working Tuesdays
|
result.working_days.tuesdays | string |
Working Tuesdays within the period |
|
All working Wednesdays
|
result.working_days.wednesdays | string |
Working Wednesdays within the period |
|
All working Thursdays
|
result.working_days.thursdays | string |
Working Thursdays within the period |
|
All working Fridays
|
result.working_days.fridays | string |
Working Fridays within the period |
|
All working Saturdays
|
result.working_days.saturdays | string |
Working Saturdays within the period |
|
All working Sundays
|
result.working_days.sundays | string |
Working Sundays within the period |
|
All working hours
|
result.working_days.work_hours | string |
Working hours within the period |
|
All wages
|
result.working_days.wages | string |
Wages within the period |
|
Total weekend days
|
result.weekend_days.total | string |
Total weekend days within the period |
|
All weekend days on Mondays
|
result.weekend_days.mondays | string |
Weekend days taking place on Mondays within the period |
|
All weekend days on Tuesdays
|
result.weekend_days.tuesdays | string |
Weekend days taking place on Tuesdays within the period |
|
All weekend days on Wednesdays
|
result.weekend_days.wednesdays | string |
Weekend days taking place on Wednesdays within the period |
|
All weekend days on Thursdays
|
result.weekend_days.thursdays | string |
Weekend days taking place on Thursdays within the period |
|
All weekend days on Fridays
|
result.weekend_days.fridays | string |
Weekend days taking place on Fridays within the period |
|
All weekend days on Saturdays
|
result.weekend_days.saturdays | string |
Weekend days taking place on Saturdays within the period |
|
All weekend days on Sundays
|
result.weekend_days.sundays | string |
Weekend days taking place on Sundays within the period |
|
Public holidays
|
result.public_holidays | object |
List of public holidays |
Check quota
Check quota of left days to use within the current month and available for the next month.
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
State
|
result.state | string |
The state of your plan (1:active, 2:cancelled, -1:error). |
|
Current
|
result.current | string |
Current quota (days left to be analyzed within this month). |
|
Next
|
result.next | string |
Quota available for next month. |
Get day information
Get detailed information about a specific day.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Date
|
date | True | string |
The date to analyze (YYYY-MM-DD) |
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Working day
|
result.working_day | string |
Is this a working day (0 means no). |
|
Working hours
|
result.work_hours | string |
Number of working hours on that day. |
|
Wages
|
result.wages | string |
Wages |
|
Morning start
|
result.morning_start | string |
Time when morning starts |
|
Morning end
|
result.morning_end | string |
Time when morning ends |
|
Afternoon start
|
result.afternoon_start | string |
Time when afternoon starts |
|
Afternoon end
|
result.afternoon_end | string |
Time when afternoon ends |
|
Public holiday
|
result.public_holiday | string |
Is this a public holiday (0 means no). |
|
Public holiday description
|
result.public_holiday_description | string |
Description of this public holiday |
|
Weekend day
|
result.weekend_day | string |
Is this a weekend day (0 means no). |
|
Custom date
|
result.custom_date | string |
Is this a custom date (0 means no). |
|
Custom date description
|
result.custom_date_description | string |
Description for this custom date. |
|
Custom date color
|
result.custom_date_color | string |
Color defined for this custom date. |
List non working days
List the non working days (weekend days, public holidays and custom dates) between 2 dates.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Country code
|
country_code | True | string |
The ISO country code (2 letters). |
|
Start date
|
start_date | True | string |
The start date (YYYY-MM-DD) |
|
End date
|
end_date | True | string |
The end date (YYYY-MM-DD) |
|
Configuration
|
configuration | string |
The name of the regional preset configuration. See documentation for more. |
|
|
Weekend
|
weekend | string |
Your weekend structure. Sunday-Monday-Tuesday-Wednesday-Thursday-Friday-Saturday. If the weekend for you is Sunday and Monday, you can send: 1100000 If the weekend is Saturday afternoon and Sunday: 1000003 |
|
|
Use custom configuration
|
use_custom_configuration | boolean |
Take into account your own personal configuration. |
|
|
Profile Id
|
profile_id | string |
If you created several profiles under your custom configuration, the ID of the profile to be used. 6 characters. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Non working days
|
result.non_working_days | object |
List of non working days. |
Locating a postal address
Sometimes it may be needed to identify which calendar configuration is relevant to a given customer's postal address. This service returns the appropriate country_code & configuration for a given postal adresss.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Address
|
address | True | string |
The postal address. It is a string with no constraint. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Status
|
result.status | string |
Address status |
|
Country code
|
result.country_code | string |
ISO country code. |
|
Configuration
|
result.configuration | string |
Address additional information. |
|
Formatted address
|
result.formatted_address | string |
Returned formatted address. |