![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-logo.png\"){kind=logo}
<\/a>Tripletex is a cloud-based accounting and enterprise resource planning (ERP) platform designed for small to medium-sized businesses in Norway and other Scandinavian countries. It provides comprehensive financial management, invoicing, project accounting, and inventory management capabilities through a robust REST API.<\/p>\nIntegrating Tripletex with SQL Server Integration Services (SSIS) enables seamless data synchronization between your accounting system and other business applications. ZappySys SSIS PowerPack simplifies this integration by providing pre-built connectors and components that handle Tripletex authentication, API communication, and data transformation without requiring custom code.<\/p>\n
This tutorial walks you through the complete process of setting up a Tripletex connection and building your first data integration package.<\/p>\n
Prerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
- Tripletex account with API access enabled.<\/li>\n
- Finally, do not forget to install\u00a0ZappySys\u00a0SSIS PowerPack.<\/a><\/li>\n<\/ol>\n
Steps<\/h2>\nGenerate your Tripletex API credentials<\/h3>\n\n- Create or log in to your Tripletex account<\/a> using your administrator credentials.<\/li>\n
- Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.<\/li>\n
- Select API Access<\/strong> from the dropdown menu.<\/li>\n
- Click the Generate New Token<\/strong> button to generate a new API token.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-generate-token-1.png\")
<\/a>Tripletex – Generate Token<\/p><\/div><\/li>\n
- Provide a descriptive name for your token.<\/li>\n
- Set the appropriate permissions scope. For this tutorial, select Read and Write<\/strong> access to ensure the integration can both retrieve and push data.<\/li>\n
- Click Generate Token<\/strong>, then immediately copy the Consumer Token<\/strong> and Employee Token<\/strong> values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-getting-tokens.png\")
<\/a>Tripletex – Getting Tokens<\/p><\/div><\/li>\n<\/ol>\n
Generate the Session Token<\/h3>\n
Tripletex requires a session token for API authentication. This session token is generated from the Consumer Token and Employee Token obtained in Step 1. Follow these steps:<\/p>\n
\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- SessionToken<\/strong> (String) \u2014 Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) \u2014 Enter your Tripletex company ID (or use 0 if unknown).<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n
![\"Add](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/07\/RestAPITask.jpg\")
<\/a>Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.value.Token<\/code> to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and\u00a0choose your SessionToken variable.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-save-session-token-in-a-variable.png\")
<\/a>Tripletex – Save Session Token in Variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n - Set the HTTP Request Method<\/strong> to PUT<\/strong>.<\/li>\n
- Test the connection. If successful, you will see the generated session token in the response.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-generate-session-token.png\")
<\/a>Tripletex – Generate Session Token<\/p><\/div><\/li>\n<\/ol>\n
Use the HTTP dynamic token connection(Recommended)<\/h3>\n
An alternative option is using the Dynamic token inside the HTTP connection<\/p>\n
\n- Right-click in the Connection Managers<\/strong> pane and select New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Create-a-new-HTTP-connection.png\")
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Enter the following URL with the consumer and employee token:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-04-28<\/pre>\n<\/li>\n - In Credentials Type<\/strong>, select Dynamic Token.<\/strong><\/strong><\/li>\n
- In the Auth header name<\/strong>, use Authorization<\/strong>.<\/li>\n
- For the Auth Scheme<\/strong>, select the option Basic.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong>\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-SSIS-HTTP-connection.png\")
<\/a>Tripletex – SSIS HTTP connection<\/p><\/div><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the past URL.<\/li>\n
- Set up the HTTP<\/strong> Request Method to PUT.
\n<\/strong><\/p>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-ODBC-dynamic-token.png\")
<\/a>Tripletex – ODBC dynamic token<\/p><\/div><\/li>\n
- Go to the Response Settings<\/strong> tab<\/li>\n
- Select Expression Type<\/strong> as JSON<\/strong> and use this JSONPath to get the Session Token: $.value.token<\/span><\/li>\n
- In Token Function<\/strong>, use the following function. The Authorization header must contain the Company ID( Enter your Tripletex company ID or use 0 if unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>><\/span><\/li>\n
- Click OK<\/strong> to save the connection configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-SSIS-save-Session-Token.png\")
<\/a>Tripletex – SSIS save Session Token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure the JSON Source<\/h3>\n\n- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n
![\"SSIS](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- For testing purposes, enter the following URL:\n
https:\/\/api-test.tripletex.tech\/v2\/currency<\/pre>\n<\/li>\n
- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click the Headers<\/strong> tab and add the required Tripletex authentication headers. The Authorisation header must contain the Company ID and Session Token in Base64-encoded format:\n
Accept: application\/json\r\nAuthorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>><\/pre>\n<\/div>\n<\/li>\n- If you want to use the connection option\u00a0(Recommended), just check\u00a0Use credentials<\/strong> and select the connection you created earlier.<\/li>\n
- In the Array Filter<\/strong> field, specify the JSON path to extract the data array from the Tripletex response:
$.value<\/code><\/li>\n- Click Preview Data<\/strong> to test the connection and verify that data is being retrieved correctly from Tripletex.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-JSON-Source-result.png\")
<\/a>Tripletex – JSON Source result<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Tripletex data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
Steps<\/h2>\nGenerate your Tripletex API credentials<\/h3>\n\n- Create or log in to your Tripletex account<\/a> using your administrator credentials.<\/li>\n
- Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.<\/li>\n
- Select API Access<\/strong> from the dropdown menu.<\/li>\n
- Click the Generate New Token<\/strong> button to generate a new API token.\n<\/a>
Tripletex – Generate Token<\/p><\/div><\/li>\n
- Provide a descriptive name for your token.<\/li>\n
- Set the appropriate permissions scope. For this tutorial, select Read and Write<\/strong> access to ensure the integration can both retrieve and push data.<\/li>\n
- Click Generate Token<\/strong>, then immediately copy the Consumer Token<\/strong> and Employee Token<\/strong> values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.\n<\/a>
Tripletex – Getting Tokens<\/p><\/div><\/li>\n<\/ol>\n
Generate the Session Token<\/h3>\n
Tripletex requires a session token for API authentication. This session token is generated from the Consumer Token and Employee Token obtained in Step 1. Follow these steps:<\/p>\n
\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- SessionToken<\/strong> (String) \u2014 Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) \u2014 Enter your Tripletex company ID (or use 0 if unknown).<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n<\/a>
Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.value.Token<\/code> to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and\u00a0choose your SessionToken variable.\n<\/a>
Tripletex – Save Session Token in Variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n - Set the HTTP Request Method<\/strong> to PUT<\/strong>.<\/li>\n
- Test the connection. If successful, you will see the generated session token in the response.\n<\/a>
Tripletex – Generate Session Token<\/p><\/div><\/li>\n<\/ol>\n
Use the HTTP dynamic token connection(Recommended)<\/h3>\n
An alternative option is using the Dynamic token inside the HTTP connection<\/p>\n
\n- Right-click in the Connection Managers<\/strong> pane and select New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list\n<\/a>
Create a new HTTP connection<\/p><\/div><\/li>\n
- Enter the following URL with the consumer and employee token:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-04-28<\/pre>\n<\/li>\n - In Credentials Type<\/strong>, select Dynamic Token.<\/strong><\/strong><\/li>\n
- In the Auth header name<\/strong>, use Authorization<\/strong>.<\/li>\n
- For the Auth Scheme<\/strong>, select the option Basic.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong>\n<\/a>
Tripletex – SSIS HTTP connection<\/p><\/div><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the past URL.<\/li>\n
- Set up the HTTP<\/strong> Request Method to PUT.
\n<\/strong><\/p>\n<\/a>Tripletex – ODBC dynamic token<\/p><\/div><\/li>\n
- Go to the Response Settings<\/strong> tab<\/li>\n
- Select Expression Type<\/strong> as JSON<\/strong> and use this JSONPath to get the Session Token: $.value.token<\/span><\/li>\n
- In Token Function<\/strong>, use the following function. The Authorization header must contain the Company ID( Enter your Tripletex company ID or use 0 if unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>><\/span><\/li>\n
- Click OK<\/strong> to save the connection configuration.\n<\/a>
Tripletex – SSIS save Session Token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure the JSON Source<\/h3>\n\n- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- For testing purposes, enter the following URL:\n
https:\/\/api-test.tripletex.tech\/v2\/currency<\/pre>\n<\/li>\n
- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click the Headers<\/strong> tab and add the required Tripletex authentication headers. The Authorisation header must contain the Company ID and Session Token in Base64-encoded format:\n
Accept: application\/json\r\nAuthorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>><\/pre>\n<\/div>\n<\/li>\n- If you want to use the connection option\u00a0(Recommended), just check\u00a0Use credentials<\/strong> and select the connection you created earlier.<\/li>\n
- In the Array Filter<\/strong> field, specify the JSON path to extract the data array from the Tripletex response:
$.value<\/code><\/li>\n- Click Preview Data<\/strong> to test the connection and verify that data is being retrieved correctly from Tripletex.\n<\/a>
Tripletex – JSON Source result<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Tripletex data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- \n
- Create or log in to your Tripletex account<\/a> using your administrator credentials.<\/li>\n
- Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.<\/li>\n
- Select API Access<\/strong> from the dropdown menu.<\/li>\n
- Click the Generate New Token<\/strong> button to generate a new API token.\n
<\/a>Tripletex – Generate Token<\/p><\/div><\/li>\n
- Provide a descriptive name for your token.<\/li>\n
- Set the appropriate permissions scope. For this tutorial, select Read and Write<\/strong> access to ensure the integration can both retrieve and push data.<\/li>\n
- Click Generate Token<\/strong>, then immediately copy the Consumer Token<\/strong> and Employee Token<\/strong> values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.\n
<\/a>Tripletex – Getting Tokens<\/p><\/div><\/li>\n<\/ol>\n
Generate the Session Token<\/h3>\n
Tripletex requires a session token for API authentication. This session token is generated from the Consumer Token and Employee Token obtained in Step 1. Follow these steps:<\/p>\n
- \n
- In your SSIS package, navigate to the Variables section and create the following variables:\n
- \n
- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- SessionToken<\/strong> (String) \u2014 Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) \u2014 Enter your Tripletex company ID (or use 0 if unknown).<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n
<\/a>Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.value.Token<\/code> to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and\u00a0choose your SessionToken variable.\n
<\/a>Tripletex – Save Session Token in Variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to PUT<\/strong>.<\/li>\n
- Test the connection. If successful, you will see the generated session token in the response.\n
<\/a>Tripletex – Generate Session Token<\/p><\/div><\/li>\n<\/ol>\n
Use the HTTP dynamic token connection(Recommended)<\/h3>\n
An alternative option is using the Dynamic token inside the HTTP connection<\/p>\n
- \n
- Right-click in the Connection Managers<\/strong> pane and select New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list\n
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Enter the following URL with the consumer and employee token:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-04-28<\/pre>\n<\/li>\n- In Credentials Type<\/strong>, select Dynamic Token.<\/strong><\/strong><\/li>\n
- In the Auth header name<\/strong>, use Authorization<\/strong>.<\/li>\n
- For the Auth Scheme<\/strong>, select the option Basic.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong>\n
<\/a>Tripletex – SSIS HTTP connection<\/p><\/div><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the past URL.<\/li>\n
- Set up the HTTP<\/strong> Request Method to PUT.
\n<\/strong><\/p>\n<\/a>Tripletex – ODBC dynamic token<\/p><\/div><\/li>\n
- Go to the Response Settings<\/strong> tab<\/li>\n
- Select Expression Type<\/strong> as JSON<\/strong> and use this JSONPath to get the Session Token: $.value.token<\/span><\/li>\n
- In Token Function<\/strong>, use the following function. The Authorization header must contain the Company ID( Enter your Tripletex company ID or use 0 if unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>><\/span><\/li>\n
- Click OK<\/strong> to save the connection configuration.\n
<\/a>Tripletex – SSIS save Session Token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure the JSON Source<\/h3>\n
- \n
- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- For testing purposes, enter the following URL:\n
https:\/\/api-test.tripletex.tech\/v2\/currency<\/pre>\n<\/li>\n
- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click the Headers<\/strong> tab and add the required Tripletex authentication headers. The Authorisation header must contain the Company ID and Session Token in Base64-encoded format:\n
Accept: application\/json\r\nAuthorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>><\/pre>\n<\/div>\n<\/li>\n- If you want to use the connection option\u00a0(Recommended), just check\u00a0Use credentials<\/strong> and select the connection you created earlier.<\/li>\n
- In the Array Filter<\/strong> field, specify the JSON path to extract the data array from the Tripletex response:
$.value<\/code><\/li>\n- Click Preview Data<\/strong> to test the connection and verify that data is being retrieved correctly from Tripletex.\n
<\/a>Tripletex – JSON Source result<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n
- \n
- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Tripletex data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n