共用方式為


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 tomasz@poszytek.eu
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.