Calculate Working Day

The Calculate Working Day connector is a tool for developers to easily compute a valid working day, accommodating a range of requirements from basic to complex scenarios.

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 Mightora.io
URL https://mightora.io/calculate-working-day/
Email support@mightora.io
Connector Metadata
Publisher Mightora.io
Website https://mightora.io
Privacy policy https://mightora.io/privacy/
Categories Marketing;Data

Calculate working day

The Calculate Working Day API is a tool for developers to easily compute a valid working day, accommodating a range of requirements from basic to complex scenarios. It seamlessly integrates with user-defined working days and UK bank holidays and can perform a number of functions. With a more advanced setup, developers can tailor the computation to adhere to specific working day patterns. By supplying a customized list of working days—designated by their corresponding day-of-week codes—the API can precisely determine the subsequent working day, considering the user-defined schedule.

Publisher: Mightora.io

At Mightora.io, we are dedicated to transforming your development process by offering exceptional Power Automate connectors and APIs. Our goal is to not only reduce your development costs but also empower your developers to embrace citizen development. With our innovative solutions, you can expect a seamless and efficient development experience that will drive your success forward. More information can be found on our website

Prerequisites

To use this connector you will need the following to proceed:

  • A Microsoft Power Apps or Power Automate plan
  • An API key from our website choosing billing from either RapidAPI or Blobr

Supported Operations

Combined

Performs a combination of all of the endpoints in one response.

Basic Next Working Day

Finds the next working day based on a working week of Monday to Friday.

Date Difference Calculator

This action uses multiple variables to determine what your working days are between two dates.

Next Working Day

This action uses multiple variables to determine what your working days are in order to return the correct Next Working Day after the date you provide.

First and Last Working Day of Month

This action uses multiple variables to determine what your First and Last working days of a given month are.

Is Today A Working Day

This action uses multiple variables to determine if today/date supplied is a working day for you.

Date In X Working Days

This action uses multiple variables to determine what the working day will be in X working days’ time.

Obtaining Credentials

Our connectors are free to use, if you are asked for an api-key use free as the key value. The full process is outlined below. For support please head on over to our website here.

Getting Started

You can use this connector in the following cases:

  1. Make your connection, if you are asked for an api-key use free as the key value.
  2. Add the step in to your Power Automate Flow
  3. Enter in your api key and select your endpoint
  4. Pass in the value of your domain, you can also pass in a full email address however we only need the domain

Known Issues and Limitations

  • Currently there are no known issues
  • Currently we limit to 1 call per second, if you need greater capacity please reach out to us directly.

Using the connector

To use our connector;

  1. Add it in to your Power Automate Flow.
  2. Create your connection by entering free if asked for a key.
  3. Choose your action
  4. Pass in the optional and required parameters depending on the action.

Parameters that can be used

  • date - The date in question you wish to centre your request around. This is the input date in YYYY-MM-DD format. e.g. 2022-12-23.
  • working_days - This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is '1,2,3,4,5'.
  • x_working_days - Find working day in X days e.g. 4
  • start_date - The start date in YYYY-MM-DD format. e.g. 2022-12-23.
  • end_date - The end date in YYYY-MM-DD format. e.g. 2022-12-30.
  • country - Currently, only the United Kingdom is supported. Values can be england-and-wales, scotland, northern-ireland, none. Used to filter out bank holidays.
  • non_working_days - A custom list of non working days, this could be a list of days where service is not available. In a string as a list, format YYYY-MM-DD,YYYY-MM-DD e.g. 2022-12-28,2022-12-29,2022-12-30.

Deployment Instructions

You can use this connector in the following cases:

  1. Make your connection, if you are asked for an api-key use free as the key value.
  2. Add the step in to your Power Automate Flow
  3. Enter in your api key and select your endpoint
  4. Pass in the value of your domain, you can also pass in a full email address however we only need the domain

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
x-mightora-key securestring The x-mightora-key for this api True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Basic Next Working Day

Finds the next working day based on a working week of Monday to Friday.

Combination of all Calculate Working Day Endpoints

Performs a combination of all of the endpoints in one response. For more information please see https://mightora.io/calculate-working-day

Date In X Working Days

This action uses multiple variables to determine what the working day will be in X working days’ time.

First And Last Working Day Of Month

This action uses multiple variables to determine what your First and Last working days of a given month are.

Is Today A Working Day

This action uses multiple variables to determine if today is a working day for you.

Next Working Day

This action uses multiple variables to determine what your working days are in order to return the correct Next Working Day after the date you provide.

Basic Next Working Day

Finds the next working day based on a working week of Monday to Friday.

Parameters

Name Key Required Type Description
API Endpoint Host
endpoint True string

The API Endpoint Host you wish to use

Date
date True string

This is the input date in YYYY-MM-DD format. e.g. 2022-12-23

Returns

Name Path Type Description
Input Date
input_date string

input_date

Next working day
next_working_day string

next_working_day

More info
more_info string

more_info

Message from developer
message_from_developer string

message_from_developer

Combination of all Calculate Working Day Endpoints

Performs a combination of all of the endpoints in one response. For more information please see https://mightora.io/calculate-working-day

Parameters

Name Key Required Type Description
API Endpoint Host
endpoint True string

The API Endpoint Host you wish to use

Date
date True string

This is the input date in YYYY-MM-DD format. e.g. 2022-12-23

Working Days
working_days True string

This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is "1,2,3,4,5".

Non working days
non_working_days string

A custom list of non working days, this could be a list of days where service is not available. In a string as a list, format YYYY-MM-DD,YYYY-MM-DD e.g. 2022-12-28,2022-12-29,2022-12-30

In X working days
x_working_days True integer

Find working day in X days e.g. 4

Filter bank holidays for Country
country string

Currently only the United Kindom is supported

Returns

Name Path Type Description
Input Date
input_date string

input_date

Is input date a working day
is_input_date_a_working_day boolean

is_input_date_a_working_day

Working Days
working_days array of string

working_days

Working Days in Words
working_days_in_words array of string

working_days_in_words

Working Days in Words
non_working_days array of string

non_working_days

Next working day
next_working_day string

next_working_day

Next working day
x_days integer

x_days

Working day in x days
working_day_in_x_days string

working_day_in_x_days

First Working day of month
first_working_day_of_month string

first_working_day_of_month

Last working day of month
last_working_day_of_month string

last_working_day_of_month

More info
more_info string

more_info

Message from developer
message_from_developer string

message_from_developer

Date In X Working Days

This action uses multiple variables to determine what the working day will be in X working days’ time.

Parameters

Name Key Required Type Description
API Endpoint Host
endpoint True string

The API Endpoint Host you wish to use

Date
date True string

This is the input date in YYYY-MM-DD format. e.g. 2022-12-23

Working Days
working_days True string

This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is "1,2,3,4,5".

In X working days
x_working_days True integer

Find working day in X days e.g. 4

Returns

Name Path Type Description
Input Date
input_date string

input_date

Working Days
working_days array of string

working_days

Working Days in Words
working_days_in_words array of string

working_days_in_words

Working Days in Words
non_working_days array of string

non_working_days

Next working day
x_days integer

x_days

Working day in x days
working_day_in_x_days string

working_day_in_x_days

More info
more_info string

more_info

Message from developer
message_from_developer string

message_from_developer

First And Last Working Day Of Month

This action uses multiple variables to determine what your First and Last working days of a given month are.

Parameters

Name Key Required Type Description
API Endpoint Host
endpoint True string

The API Endpoint Host you wish to use

Date
date True string

This is the input date in YYYY-MM-DD format. e.g. 2022-12-23

Working Days
working_days True string

This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is "1,2,3,4,5".

Returns

Name Path Type Description
Input Date
input_date string

input_date

Working Days
working_days array of string

working_days

Working Days in Words
working_days_in_words array of string

working_days_in_words

Working Days in Words
non_working_days array of string

non_working_days

First Working day of month
first_working_day_of_month string

first_working_day_of_month

Last working day of month
last_working_day_of_month string

last_working_day_of_month

More info
more_info string

more_info

Message from developer
message_from_developer string

message_from_developer

Is Today A Working Day

This action uses multiple variables to determine if today is a working day for you.

Parameters

Name Key Required Type Description
API Endpoint Host
endpoint True string

The API Endpoint Host you wish to use

Date
date True string

This is the input date in YYYY-MM-DD format. e.g. 2022-12-23

Working Days
working_days True string

This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is "1,2,3,4,5".

Returns

Name Path Type Description
Input Date
input_date string

input_date

Is input date a working day
is_input_date_a_working_day boolean

is_input_date_a_working_day

Working Days
working_days array of string

working_days

Working Days in Words
working_days_in_words array of string

working_days_in_words

Working Days in Words
non_working_days array of string

non_working_days

More info
more_info string

more_info

Message from developer
message_from_developer string

message_from_developer

Next Working Day

This action uses multiple variables to determine what your working days are in order to return the correct Next Working Day after the date you provide.

Parameters

Name Key Required Type Description
API Endpoint Host
endpoint True string

The API Endpoint Host you wish to use

Date
date True string

This is the input date in YYYY-MM-DD format. e.g. 2022-12-23

Working Days
working_days True string

This parameter expects a comma-separated list of working days, where Monday is 1, Tuesday is 2, and so on. In the default, we're using all weekdays from Monday to Friday, so the value is "1,2,3,4,5".

Non working days
non_working_days string

A custom list of non working days, this could be a list of days where service is not available. In a string as a list, format YYYY-MM-DD,YYYY-MM-DD e.g. 2022-12-28,2022-12-29,2022-12-30

In X working days
x_working_days True integer

Find working day in X days e.g. 4

Returns

Name Path Type Description
Input Date
input_date string

input_date

Working Days
working_days array of string

working_days

Working Days in Words
working_days_in_words array of string

working_days_in_words

Working Days in Words
non_working_days array of string

non_working_days

Next working day
next_working_day string

next_working_day

More info
more_info string

more_info

Message from developer
message_from_developer string

message_from_developer