![\"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 used by small and medium-sized businesses in Norway and other Scandinavian countries. It provides financial management, invoicing, project accounting, and inventory features through a REST API.<\/p>\nIntegrating Tripletex with SQL Server Integration Services (SSIS) lets you synchronize accounting data with databases, reporting systems, and other business applications. ZappySys SSIS PowerPack simplifies this process by providing components that handle HTTP requests, authentication, and data extraction without requiring custom code.<\/p>\n
This tutorial walks you through the complete process of creating Tripletex API credentials, generating a session token, and building an SSIS package that extracts data from Tripletex.<\/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
- Install ZappySys SSIS PowerPack<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\nGenerate 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 a Tripletex session token<\/h3>\n
Tripletex requires a session token for API authentication. The session token is generated from the Consumer Token and Employee Token obtained in the previous step.<\/p>\n
\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- ConsumerToken<\/strong> (String) — Enter the Consumer Token from the previous step.<\/li>\n
- EmployeeToken<\/strong> (String) — Enter the Employee Token from the previous step.<\/li>\n
- SessionToken<\/strong> (String) — Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) — Enter your Tripletex company ID, or use 0 if it is 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>, select the Variable<\/strong> option, and choose 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-12-31<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-12-31<\/pre>\n<\/li>\n - Use a future expiration date when you generate the token. If you copy these examples later, replace the sample date before testing.<\/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 an HTTP dynamic token connection (recommended)<\/h3>\n
You can also generate and reuse the session token through an HTTP connection with a dynamic token configuration.<\/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-12-31<\/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 Basic<\/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 previous URL.<\/li>\n
- Set the HTTP Request Method<\/strong> 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 it is 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 Authorization 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 (recommended), select Use credentials<\/strong> and choose 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 dialog.<\/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 data extraction is working correctly.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Final-Result.png\")
<\/a>Tripletex – Final Result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
You have now set up a complete integration between Tripletex and SSIS using ZappySys components. This tutorial covered creating API credentials, configuring session token authentication, retrieving data from the Tripletex API, and loading it into SQL Server or another destination.<\/p>\n
This pattern can help automate business processes such as invoice tracking, customer synchronization, project reporting, and financial analysis. By using ZappySys SSIS PowerPack, you can build the workflow with less custom code while keeping the package easier to maintain.<\/p>\n
Steps<\/h2>\nGenerate 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 a Tripletex session token<\/h3>\n
Tripletex requires a session token for API authentication. The session token is generated from the Consumer Token and Employee Token obtained in the previous step.<\/p>\n
\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- ConsumerToken<\/strong> (String) — Enter the Consumer Token from the previous step.<\/li>\n
- EmployeeToken<\/strong> (String) — Enter the Employee Token from the previous step.<\/li>\n
- SessionToken<\/strong> (String) — Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) — Enter your Tripletex company ID, or use 0 if it is 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>, select the Variable<\/strong> option, and choose 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-12-31<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-12-31<\/pre>\n<\/li>\n - Use a future expiration date when you generate the token. If you copy these examples later, replace the sample date before testing.<\/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 an HTTP dynamic token connection (recommended)<\/h3>\n
You can also generate and reuse the session token through an HTTP connection with a dynamic token configuration.<\/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-12-31<\/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 Basic<\/strong>.\n<\/a>
Tripletex – SSIS HTTP connection<\/p><\/div><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the previous URL.<\/li>\n
- Set the HTTP Request Method<\/strong> 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 it is 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 Authorization 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 (recommended), select Use credentials<\/strong> and choose 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 dialog.<\/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 data extraction is working correctly.\n<\/a>
Tripletex – Final Result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
You have now set up a complete integration between Tripletex and SSIS using ZappySys components. This tutorial covered creating API credentials, configuring session token authentication, retrieving data from the Tripletex API, and loading it into SQL Server or another destination.<\/p>\n
This pattern can help automate business processes such as invoice tracking, customer synchronization, project reporting, and financial analysis. By using ZappySys SSIS PowerPack, you can build the workflow with less custom code while keeping the package easier to maintain.<\/p>\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 a Tripletex session token<\/h3>\n
Tripletex requires a session token for API authentication. The session token is generated from the Consumer Token and Employee Token obtained in the previous step.<\/p>\n
- \n
- In your SSIS package, navigate to the Variables section and create the following variables:\n
- \n
- ConsumerToken<\/strong> (String) — Enter the Consumer Token from the previous step.<\/li>\n
- EmployeeToken<\/strong> (String) — Enter the Employee Token from the previous step.<\/li>\n
- SessionToken<\/strong> (String) — Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) — Enter your Tripletex company ID, or use 0 if it is 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>, select the Variable<\/strong> option, and choose 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-12-31<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-12-31<\/pre>\n<\/li>\n- Use a future expiration date when you generate the token. If you copy these examples later, replace the sample date before testing.<\/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 an HTTP dynamic token connection (recommended)<\/h3>\n
You can also generate and reuse the session token through an HTTP connection with a dynamic token configuration.<\/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-12-31<\/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 Basic<\/strong>.\n
<\/a>Tripletex – SSIS HTTP connection<\/p><\/div><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the previous URL.<\/li>\n
- Set the HTTP Request Method<\/strong> 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 it is 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 Authorization 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 (recommended), select Use credentials<\/strong> and choose 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 dialog.<\/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 data extraction is working correctly.\n
<\/a>Tripletex – Final Result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
You have now set up a complete integration between Tripletex and SSIS using ZappySys components. This tutorial covered creating API credentials, configuring session token authentication, retrieving data from the Tripletex API, and loading it into SQL Server or another destination.<\/p>\n
This pattern can help automate business processes such as invoice tracking, customer synchronization, project reporting, and financial analysis. By using ZappySys SSIS PowerPack, you can build the workflow with less custom code while keeping the package easier to maintain.<\/p>\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) — Enter the Employee Token from the previous step.<\/li>\n
- ConsumerToken<\/strong> (String) — Enter the Consumer Token from the previous step.<\/li>\n