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

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.

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

How to get credentials

Credentials can be obtained from one of our two billing partners, either from RapidAPI or Blobr. The full process is outlined below. For support please head on over to our website here.

How to get credentials from Rapid API

1. Go to RapidAPI
2. Sign up for an account
3. Click on Subscribe to Test
4. Choose your plan, the Basic plan is free
5. Subscribe to the plan
6. Then click on Endpoints and copy the value from X-RapidAPI-Key
7. Paste the value into the API Key field
8. Choose RapidAPI as your Endpoint

How to get credentials from Blobr

1. Go to Blobr
2. Sign up for an account
3. Click on Try for free
4. Enter in your details, the trial is free
5. Subscribe to the plan
6. Then click on Authentication and copy the value from Primary API Key
7. Paste the value into the API Key field
8. Choose Blobr as your Endpoint

Get started with your connector

You can use this connector in the following cases:

1. Obtain a api key either from RapidAPI or Blobr.
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 knonw issues
• Currently we limit to 1000 calls per minute per api key, we will look to increase this if there is demand

Common errors and remedies

Check the endpoint you have chosen is correct for the API key you have

FAQ

What date format should I use

Please use YYYY-MM-DD for all dates, e.g. 2022-12-23 for the 23rd of December 2023

My API Key is not working

Please make sure you have the correct endpoint selected.

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

Operation ID:

BasicNextWorkingDay

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

Operation ID:

Combined

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

Operation ID:

DateInXWorkingDays

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

Operation ID:

FirstAndLastWorkingDayOfMonth

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

Operation ID:

IsTodayAWorkingDay

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

Operation ID:

NextWorkingDay

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