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/ |
| 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
- Go to RapidAPI
- Sign up for an account
- Click on Subscribe to Test
- Choose your plan, the Basic plan is free
- Subscribe to the plan
- Then click on Endpoints and copy the value from X-RapidAPI-Key
- Paste the value into the API Key field
- Choose RapidAPI as your Endpoint
How to get credentials from Blobr
- Go to Blobr
- Sign up for an account
- Click on Try for free
- Enter in your details, the trial is free
- Subscribe to the plan
- Then click on Authentication and copy the value from Primary API Key
- Paste the value into the API Key field
- Choose Blobr as your Endpoint
Get started with your connector
You can use this connector in the following cases:
- Obtain a api key either from RapidAPI or Blobr.
- Add the step in to your Power Automate Flow
- Enter in your api key and select your endpoint
- 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
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 |