Configure the API-Based Accruals Import Integration
This topic describes how to configure this integration.
This integration pack contains the following integration processes:
- Accruals Balances Earned and Reset
- Accruals Move Between Bins
Tip: For an overview of API-based integrations and example APIs, see API-Based Integrations.
Before you start
Deploy the API-AccrualImport > API-AccrualEarnedImport, API-AccrualResetImport, or API-AccrualMoveToBinImport integration pack; see Deploy Integrations.
This integration contains the following integration processes:
- Accrual Earned Import: Import accruals balances.
- Accrual Reset Import: Import accruals balances to update existing records.
Request format
Requests to the integration must be in JSON and have the following sections:
- Parameters: To pass from the source
- Data: For the integration to process
Configure the integration
Select the environment
-
Open the Integration Template Designer: Select Main Menu
> Administration > Application Setup > Integrations Setup > Design Integration Templates. Uwaga: If prompted, enter your Username and Password. Kliknij Dotknij Log in.
- Wybierz kartę Zarządzaj > Zarządzanie atomem.
- Wybierz swoje środowisko.
Select environment extensions
- In Administration, kliknij dotknij Environment Extensions.
- In Process Filter, kliknij dotknij the magnifying glass
. It can take several seconds before the button becomes active. - Scroll to and select the integration pack: API-AccrualImport > API-AccrualEarnedImport or API-AccrualResetImport.
Przestroga :Jeśli wybierzesz Użyj wartości domyślnej w ustawieniach połączenia i właściwościach procesu, upewnij się, że Wartość jest pusta. Jeśli Wartość nie jest pusta, wartość ta uchyla wartość domyślną niezależnie od tego, czy wybrano opcję Użyj domyślnej, czy wyczyszczono ją. Przykład: Jeśli wartość domyślna to abc, ale Wartość pokazuje xyz, integracja wykorzystuje xyz niezależnie od ustawienia Użyj wartości domyślnej.
Configure connection settings
- Select Connection Settings.
-
From the Connection dropdown list, select and configure:
Connection Settings Setting Required Actions APIGatewayServer Required (Opcjonalnie) Aby zmienić domyślny serwer bramy API:
- Wyczyść Użyj wartości domyślnej.
- Wprowadź Adres URL do serwera.
Przykład: <URLdzierżawcy>/api
AuthenticationServer Required - Clear Use Default.
- Enter the URL to the OpenAM server. OpenAM is an open-source server platform that manages access, authentication, authorization rules, entitlement, and federation. The URL must contain the server name and port followed by openam/oauth2. Example: http://<servername>:9012/openam/oauth2
Configure process properties
Process properties apply globally to all records that an integration processes. When you install the integration, you can define the parameter values or configure a prompt for the user to define the value when they run the integration.
Uwaga: Most of the process properties have default values, even though the Integration Template Designer does not display these values.
- Select Process Properties.
-
AuthenticationProperties define properties to connect to the authentication server and get the access token to execute APIs. Leave all of these values at their default settings.
-
Set process properties that must be configured before the integration can run. From the Process Property dropdown list, select one of the following:
- APIIntegrationAccrualBalanceEarned_ProcessProperties
- APIIntegrationAccrualBalanceReset_ProcessProperties
As needed, select any of the properties:
Process Properties Property Required Actions _IsCustomInput Not required The standard payload is the default ordering or sequence of the fields that is defined in the PredefinedInputProfile - PredefinedInputProfile data map.
To use a custom formatted input payload in which the field names and ordering are defined in the CustomProfile - PredefinedInputProfile data map:
- Clear Use Default.
- In Value, select True.
Select data maps
To customize data transformation, select the data map extension.
- Select Data Maps.
- From the Data Maps dropdown list, select one of the following:
- PredefinedInputProfile — PredefinedInputProfile (default map): Accept a predefined order of fields from the source file. The names match the fields in the data map. The _IsCustomInput process property must be set to false.
CustomProfile — PredefinedInputProfile: Define a custom map with your own fields and ordering to map the data from the source to the destination. The _IsCustomInput process property must be set to true.
-
Wybierz
, aby rozwinąć lub
, aby zwinąć poziomy.Aby rozwinąć wszystkie poziomy, kliknij prawym przyciskiem myszy ikonę zielonych pól
. Wybierz Rozwiń wszystkoWiersze pokazują powiązania między polami w źródle (lewa strona), wszystkimi funkcjami pośrednimi i miejscem docelowym (prawa strona).
-
(Optional)
Przestroga :The default mappings are developed and tested based on best practices. If you make changes, you may get unexpected results. Modify and test carefully.
- Change mappings — When you customize a default data map, you can add fields only to the end of the map.
You can select and drag to change the links between the source (left column), function (middle column), and destination (right column) items. A single source field can link to multiple destination fields, but a destination field can link to only one source field.
- Transform the data — A map can include intermediate functions that transform the data. Examples: Perform mathematical calculations on the values or get values from a cross-reference table.
Uwaga: To override a field — for example because you cannot delete it from a default map — insert a function that has a null output.
- In Function, kliknij dotknij the plus button
to add an intermediate function.
- From Category, select a category of functions:
String — Trim, add to, concatenate, replace, remove, split, or change the case of text.
Przestroga : Do not use special characters such as angle brackets (< or >) in data in cross-reference tables, data maps, and input files. These characters can make the integration fail.
Numeric — Perform mathematical calculations on the data.
Date — Change the format or get the current date.
Lookup — Get data from a cross-reference table (CRT), document cache, SQL query, or define a key-value change.
Connector — Call a value from a connector to an application or data source.
Custom Scripting — Transform data by way of Groovy or JavaScript code.
Properties — Get or set process or document properties.
- Select the function from the list in the selected category.
- Kliknij Dotknij OK.
- If prompted in Configure Defaults, enter the relevant values. Select a Caching. Kliknij Dotknij OK.
- Select and drag from a source field to an input of the function.
- Select and drag from the output of the function to a destination field.
- Repeat to add another function.
- In Function, kliknij dotknij the plus button
- Change mappings — When you customize a default data map, you can add fields only to the end of the map.
- When you finish, kliknij dotknij OK.
This integration moves accrual balances between an employee’s accrual buckets.
- Trigger an earning in one accrual code based on the balance in another accrual code. Adjust the balance in the trigger code so that the earning can occur again later.
- Transfer time from one accrual code to another when requested by an employee. Example: Move the unused accruals from Sick to Vacation at the end of the year.
- Typically done yearly. Example: Account for unused vacation at the start of a new year.
- Can be used to process rehired employees.
- Creates an input.csv file.
- Cannot accept zero or negative amounts.
Request format
Requests to the integration must be in JSON and have the following sections:
- Parameters: To pass from the source
- Data: For the integration to process
Configure the integration
Select the environment
-
Open the Integration Template Designer: Select Main Menu
> Administration > Application Setup > Integrations Setup > Design Integration Templates. Uwaga: If prompted, enter your Username and Password. Kliknij Dotknij Log in.
- Wybierz kartę Zarządzaj > Zarządzanie atomem.
- Wybierz swoje środowisko.
Select environment extensions
- In Administration, kliknij dotknij Environment Extensions.
- In Process Filter, kliknij dotknij the magnifying glass
. It can take several seconds before the button becomes active. - Scroll to and select the integration pack: API-AccrualImport > API-AccrualMoveToBinImport.
Przestroga :Jeśli wybierzesz Użyj wartości domyślnej w ustawieniach połączenia i właściwościach procesu, upewnij się, że Wartość jest pusta. Jeśli Wartość nie jest pusta, wartość ta uchyla wartość domyślną niezależnie od tego, czy wybrano opcję Użyj domyślnej, czy wyczyszczono ją. Przykład: Jeśli wartość domyślna to abc, ale Wartość pokazuje xyz, integracja wykorzystuje xyz niezależnie od ustawienia Użyj wartości domyślnej.
Configure connection settings
- Select Connection Settings.
-
From the Connection dropdown list, select and configure:
Connection Settings Setting Required Actions APIGatewayServer Required (Opcjonalnie) Aby zmienić domyślny serwer bramy API:
- Wyczyść Użyj wartości domyślnej.
- Wprowadź Adres URL do serwera.
Przykład: <URLdzierżawcy>/api
AuthenticationServer Required - Clear Use Default.
- Enter the URL to the OpenAM server. OpenAM is an open-source server platform that manages access, authentication, authorization rules, entitlement, and federation. The URL must contain the server name and port followed by openam/oauth2. Example: http://<servername>:9012/openam/oauth2
Configure process properties
Process properties apply globally to all records that an integration processes. When you install the integration, you can define the parameter values or configure a prompt for the user to define the value when they run the integration.
Uwaga: Most of the process properties have default values, even though the Integration Template Designer does not display these values.
- Select Process Properties.
-
AuthenticationProperties define properties to connect to the authentication server and get the access token to execute APIs. Leave all of these values at their default settings.
-
From the Process Property dropdown list, select APIIntegrationAccrualMoveBetweenBins_ProcessProperties to set process properties that must be configured before the integration can run.
Process Properties Property Required Actions _IsCustomInput Not required The standard payload is the default ordering or sequence of the fields that is defined in the PredefinedInputProfile - PredefinedInputProfile data map.
To use a custom formatted input payload in which the field names and ordering are defined in the CustomProfile - PredefinedInputProfile data map:
- Clear Use Default.
- In Value, select True.
_SpecialMappingRequired Not required To map the accrual codes from the input file to the accrual codes:
- Clear Use Default.
- In Value, select true.
Select data maps
To customize data transformation, select the data map extension.
- Select Data Maps.
- From the Data Maps dropdown list, select one of the following:
- APIIntMBBInputDefinedCSV — APIIntMBBInputDefinedCSV (default map): Accept a predefined order of fields from the source file. The names match the fields in the data map. The _IsCustomInput process property must be set to false.
- APIIntMBBCustomMapLHS — APIIntMBBInputDefinedCSV: Define a custom map with your own fields and ordering to map the data from the source to the destination. The _IsCustomInput process property must be set to true.
-
Wybierz
, aby rozwinąć lub
, aby zwinąć poziomy.Aby rozwinąć wszystkie poziomy, kliknij prawym przyciskiem myszy ikonę zielonych pól
. Wybierz Rozwiń wszystkoWiersze pokazują powiązania między polami w źródle (lewa strona), wszystkimi funkcjami pośrednimi i miejscem docelowym (prawa strona).
-
(Optional)
Przestroga :The default mappings are developed and tested based on best practices. If you make changes, you may get unexpected results. Modify and test carefully.
- Change mappings — When you customize a default data map, you can add fields only to the end of the map.
You can select and drag to change the links between the source (left column), function (middle column), and destination (right column) items. A single source field can link to multiple destination fields, but a destination field can link to only one source field.
- Transform the data — A map can include intermediate functions that transform the data. Examples: Perform mathematical calculations on the values or get values from a cross-reference table.
Uwaga: To override a field — for example because you cannot delete it from a default map — insert a function that has a null output.
- In Function, kliknij dotknij the plus button
to add an intermediate function.
- From Category, select a category of functions:
String — Trim, add to, concatenate, replace, remove, split, or change the case of text.
Przestroga : Do not use special characters such as angle brackets (< or >) in data in cross-reference tables, data maps, and input files. These characters can make the integration fail.
Numeric — Perform mathematical calculations on the data.
Date — Change the format or get the current date.
Lookup — Get data from a cross-reference table (CRT), document cache, SQL query, or define a key-value change.
Connector — Call a value from a connector to an application or data source.
Custom Scripting — Transform data by way of Groovy or JavaScript code.
Properties — Get or set process or document properties.
- Select the function from the list in the selected category.
- Kliknij Dotknij OK.
- If prompted in Configure Defaults, enter the relevant values. Select a Caching. Kliknij Dotknij OK.
- Select and drag from a source field to an input of the function.
- Select and drag from the output of the function to a destination field.
- Repeat to add another function.
- In Function, kliknij dotknij the plus button
- Change mappings — When you customize a default data map, you can add fields only to the end of the map.
- When you finish, kliknij dotknij OK.