# How To **URL:** https://community.linx.software/community/c/howto/5.md [Latest](https://community.linx.software/community/latest.md) · [Categories](https://community.linx.software/community/categories.md) --- ## [About the How To category](https://community.linx.software/community/t/about-the-how-to-category/14)
**Author:** [@gawie](https://community.linx.software/community/u/gawie)\ **Replies:** 0
Tips and tricks as well as overviews of achieving specific end goals. --- ## [SQL Server Connection Pool Exhaustion in Linx](https://community.linx.software/community/t/sql-server-connection-pool-exhaustion-in-linx/771)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 1\ **Last updated:** [June 4, 2026, 8:49am UTC](https://community.linx.software/community/t/sql-server-connection-pool-exhaustion-in-linx/771 "2026-06-04T08:49:02Z")
SQL Server Connection Pool Exhaustion in Linx If you are getting this error on a Linx solution using the SQL Server connection type: Timeout expired. The timeout period elapsed prior to obtaining a connection from the… --- ## [How to Configure Automatic Restart for Crashing Linx Server Services](https://community.linx.software/community/t/how-to-configure-automatic-restart-for-crashing-linx-server-services/766)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [February 9, 2026, 10:14am UTC](https://community.linx.software/community/t/how-to-configure-automatic-restart-for-crashing-linx-server-services/766 "2026-02-09T10:14:47Z")
If you ever find yourself dealing with a Linx server that keeps crashing, you can configure Windows Service Control Manager to automatically restart the service with intelligent retry logic. The Solution Use this Window… --- ## [How to Compute Days Between Two Dates in Linx (with Leap Year Support)](https://community.linx.software/community/t/how-to-compute-days-between-two-dates-in-linx-with-leap-year-support/762)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [December 12, 2025, 7:06am UTC](https://community.linx.software/community/t/how-to-compute-days-between-two-dates-in-linx-with-leap-year-support/762 "2025-12-12T07:06:28Z")
Calculating the Difference Between Two Dates in Linx (Handling Leap Years) When working with date calculations in Linx, especially for determining the difference between two dates, it’s important to ensure your approach … --- ## [Solving Date Parsing Issues: How to Handle Regional Format Differences in Linx](https://community.linx.software/community/t/solving-date-parsing-issues-how-to-handle-regional-format-differences-in-linx/761)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [December 10, 2025, 7:29am UTC](https://community.linx.software/community/t/solving-date-parsing-issues-how-to-handle-regional-format-differences-in-linx/761 "2025-12-10T07:29:31Z")
Date Parsing Issues: Understanding Regional Settings and Format Specifications in Linx When working with date data from external APIs or systems, you may encounter situations where dates are not being interpreted correct… --- ## [Handling Nulls in Linx](https://community.linx.software/community/t/handling-nulls-in-linx/742)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 1:41pm UTC](https://community.linx.software/community/t/handling-nulls-in-linx/742 "2025-04-16T13:41:49Z")
Checking for null values in Linx can be a real lifesaver—especially when working with objects that may or may not have values. This applies across various areas in Linx, including: Types Input Parameters Query or Funct… --- ## [Populate Excel Template for Specific Fields](https://community.linx.software/community/t/populate-excel-template-for-specific-fields/738)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [March 14, 2025, 9:50am UTC](https://community.linx.software/community/t/populate-excel-template-for-specific-fields/738 "2025-03-14T09:50:47Z")
Introduction You can populate data into an existing template using the Linx Excel plugin. Data population will, however, begin underneath the template. While this is perfect for templates that act as headers, you may won… --- ## [Get started with multi-threaded debugging](https://community.linx.software/community/t/get-started-with-multi-threaded-debugging/716)
**Author:** [@shamima](https://community.linx.software/community/u/shamima)\ **Replies:** 0\ **Last updated:** [September 19, 2024, 7:26am UTC](https://community.linx.software/community/t/get-started-with-multi-threaded-debugging/716 "2024-09-19T07:26:00Z")
Overview This post is designed for beginners looking to dive into multi-threaded debugging. Multi-threaded debugging is a powerful feature in Linx that simplifies debugging Services. Previously, multiple functions cou… --- ## [Convert to Base64 and Convert From Base64](https://community.linx.software/community/t/convert-to-base64-and-convert-from-base64/700)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [August 26, 2024, 12:31pm UTC](https://community.linx.software/community/t/convert-to-base64-and-convert-from-base64/700 "2024-08-26T12:31:46Z")
In Linx you can convert a string to and from Base64 by using an expression. To convert to Base64 the string must first be converted to a list of bytes (List), then the list of bytes can be converted to Base64. In the ex… --- ## [Dynamically assign SQL queries to be executed](https://community.linx.software/community/t/dynamically-assign-sql-queries-to-be-executed/692)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [May 28, 2024, 9:11am UTC](https://community.linx.software/community/t/dynamically-assign-sql-queries-to-be-executed/692 "2024-05-28T09:11:00Z")
Linx allows you to dynamically assign input parameters to most components and objects. This also allows for the dynamic assignment of SQL Queries to the ExecuteSQL component. You can thus assign queries constructed or r… --- ## [Using C# classes in Linx Expressions](https://community.linx.software/community/t/using-c-classes-in-linx-expressions/684)
**Author:** [@shamima](https://community.linx.software/community/u/shamima)\ **Replies:** 0\ **Last updated:** [March 26, 2024, 10:13am UTC](https://community.linx.software/community/t/using-c-classes-in-linx-expressions/684 "2024-03-26T10:13:21Z")
In order to access classes from certain namespaces, we prepend #. to the fully qualified name of the class. The # would indicate that the following class name will be referenced as a C# class. Classes in the System a… --- ## [Call SOAP services using REST](https://community.linx.software/community/t/call-soap-services-using-rest/498)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 2\ **Last updated:** [February 8, 2024, 11:57am UTC](https://community.linx.software/community/t/call-soap-services-using-rest/498 "2024-02-08T11:57:53Z")
SOAP, being a mature technology, have a really wide and often differently interpreted standard set. This makes it a nice tool for corporate users to manipulate into their very specific requirements and technology stack, … --- ## [How to convert a UnixTimeStamp to a datetime](https://community.linx.software/community/t/how-to-convert-a-unixtimestamp-to-a-datetime/541)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 2\ **Last updated:** [January 9, 2024, 8:55am UTC](https://community.linx.software/community/t/how-to-convert-a-unixtimestamp-to-a-datetime/541 "2024-01-09T08:55:10Z")
Unix Timestamps are often used in Web services to show specific times. For instance when an object was created or updated. There are some undocumented functions to get your Date from a Unix timestamp, especially with th… --- ## [Add an SFTP Server to your Windows Core Server using Powershell](https://community.linx.software/community/t/add-an-sftp-server-to-your-windows-core-server-using-powershell/669)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [September 13, 2023, 1:58pm UTC](https://community.linx.software/community/t/add-an-sftp-server-to-your-windows-core-server-using-powershell/669 "2023-09-13T13:58:33Z")
Sometimes users require SFTP access to their File storage on our Linx Cloud servers. Here’s the steps to set it up from a Server Management point of view. Remote Desktop into the machine and access Powershell C:\\\> po… --- ## [MariaDB Connection setup in Linx](https://community.linx.software/community/t/mariadb-connection-setup-in-linx/668)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [August 30, 2023, 3:33pm UTC](https://community.linx.software/community/t/mariadb-connection-setup-in-linx/668 "2023-08-30T15:33:28Z")
MariaDB is another valuable database type available for users and you can set Linx up to connect and use these databases. First important note is that the ODBC drivers for MariaDB is required on the system which tries t… --- ## [How to quickly create a Types from your SQL Queries](https://community.linx.software/community/t/how-to-quickly-create-a-types-from-your-sql-queries/644)
**Author:** [@Shantoie](https://community.linx.software/community/u/Shantoie)\ **Replies:** 0\ **Last updated:** [March 16, 2023, 9:41am UTC](https://community.linx.software/community/t/how-to-quickly-create-a-types-from-your-sql-queries/644 "2023-03-16T09:41:37Z")
Creating a Type can be a tedious process if it is quite big and elaborate. Luckily Linx has the Import types feature, making it easy to create Types from a JSON or XML object. To quickly create a type for the output of … --- ## [OptimoRoute API Example](https://community.linx.software/community/t/optimoroute-api-example/521)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 2\ **Last updated:** [January 11, 2023, 5:57am UTC](https://community.linx.software/community/t/optimoroute-api-example/521 "2023-01-11T05:57:06Z")
OptimoRoute™ is an online Route Planner for Delivery and Field Service. With OptimoRoute™ you can plan the most efficient routes and schedules with multiple stops per route. Sample built with Linx5. Feel free to… --- ## [Sorting a FileList by Creation Date (Or anything else)](https://community.linx.software/community/t/sorting-a-filelist-by-creation-date-or-anything-else/626)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [October 11, 2022, 7:14am UTC](https://community.linx.software/community/t/sorting-a-filelist-by-creation-date-or-anything-else/626 "2022-10-11T07:14:29Z")
By default, the FileList component does not have a property to allow you to sort your files. However, using the List functions here you can quickly filter the files yourself. Basically, first you’ll need to create a Typ… --- ## [How to page large data sets in MSSQL](https://community.linx.software/community/t/how-to-page-large-data-sets-in-mssql/620)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 12:34pm UTC](https://community.linx.software/community/t/how-to-page-large-data-sets-in-mssql/620 "2022-08-05T12:34:51Z")
When working with large data sets, and sending the data over a REST Host to show on a screen, sometimes you don’t want to send a huge amount of data at once. For instance, if you’ve got 10,000 records in your database an… --- ## [Making complex Types](https://community.linx.software/community/t/making-complex-types/619)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [August 2, 2022, 3:29pm UTC](https://community.linx.software/community/t/making-complex-types/619 "2022-08-02T15:29:32Z")
It’s quite easy to create “nested” or “complex” Types which you can use as your Request or Response for your SimpleREST Hosts. The key is to create a Type, and add it to another type… For instance, let’s say I’ve got a… --- ## [Linx 5 Server and SSL](https://community.linx.software/community/t/linx-5-server-and-ssl/376)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 1\ **Last updated:** [August 2, 2022, 7:58am UTC](https://community.linx.software/community/t/linx-5-server-and-ssl/376 "2022-08-02T07:58:40Z")
To secure your Linx solutions and set up your Linx Server to the correct ports on your server, you’ll need to work with SSL Certificates. Linx Server already contains an SSL certificate, which is valid and secure, but be… --- ## [SQLite with Linx](https://community.linx.software/community/t/sqlite-with-linx/616)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [June 14, 2022, 7:55am UTC](https://community.linx.software/community/t/sqlite-with-linx/616 "2022-06-14T07:55:59Z")
SQLite is a great alternative if you need a quick database. It’s surprisingly capable and will run on most systems. (Runs well on Windows for ARM). The SQL itself is also quite similar to what we’re used to in MSSQL and… --- ## [Generating XLS Files](https://community.linx.software/community/t/generating-xls-files/417)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [May 30, 2019, 8:36am UTC](https://community.linx.software/community/t/generating-xls-files/417 "2019-05-30T08:36:12Z")
A scenario may arise where you need generate an Excel 97 file (.xls) for certain systems. Currently in Linx, there exists an Excel plugin which allows one to read/write excel spreadsheets using the built in functions, ho… --- ## [Add a logo or watermark on images](https://community.linx.software/community/t/add-a-logo-or-watermark-on-images/123)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [February 15, 2017, 8:12am UTC](https://community.linx.software/community/t/add-a-logo-or-watermark-on-images/123 "2017-02-15T08:12:20Z")
Linx 5 has got a great component called “GraphicsMagick” which gives you a lot of different options to work with images, right there within the process. One example where I’ve used this is to add a logo on top of an imag… --- ## [Downloading files from APIs](https://community.linx.software/community/t/downloading-files-from-apis/485)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [December 1, 2020, 1:24pm UTC](https://community.linx.software/community/t/downloading-files-from-apis/485 "2020-12-01T13:24:16Z")
Download file content? Downloading file content from a REST API involves submitting a request which would then return a file as a file stream or binary content. This data is then translated into a ListTYP of the type… --- ## [Populating a Word Document](https://community.linx.software/community/t/populating-a-word-document/400)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [April 2, 2019, 3:42pm UTC](https://community.linx.software/community/t/populating-a-word-document/400 "2019-04-02T15:42:12Z")
A scenario may arise where you have a Word document that you want to populate by utilizing Linx. In Linx, there exists an Excel plugin which allows one to read/write excel spreadsheets using the built in functions, with… --- ## [Example on how to send an SMS from Linx](https://community.linx.software/community/t/example-on-how-to-send-an-sms-from-linx/296)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [July 10, 2018, 2:10pm UTC](https://community.linx.software/community/t/example-on-how-to-send-an-sms-from-linx/296 "2018-07-10T14:10:17Z")
Most companies these days requires contact with their customer through sms. This could be alerts and notifications, OTP’s or just happy birthday messages. With Linx, using the CallRESTWebService component, it couldn’t b… --- ## [Populating a Geckoboard using Linx](https://community.linx.software/community/t/populating-a-geckoboard-using-linx/379)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [February 25, 2019, 10:59am UTC](https://community.linx.software/community/t/populating-a-geckoboard-using-linx/379 "2019-02-25T10:59:52Z")
Geckoboard.com is a really easy to use Dashboarding solution that allows you to set up Live dashboards for your business. Think of those TVs you see in an operations area, ticking sales or orders off as they happen. Linx… --- ## [Linx - Google Drive - Integration Guide (CallRESTEndpoint Function)](https://community.linx.software/community/t/linx-google-drive-integration-guide-callrestendpoint-function/431)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [October 7, 2019, 10:43am UTC](https://community.linx.software/community/t/linx-google-drive-integration-guide-callrestendpoint-function/431 "2019-10-07T10:43:10Z")
Google Drive and (specific to this sample) Google Sheets, offers a RESTful Webservice API which allows you to create apps that leverage Google Drive cloud storage. You can develop applications that integrate with Google … --- ## [Aramex REST Example for South African Shipping](https://community.linx.software/community/t/aramex-rest-example-for-south-african-shipping/520)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [February 11, 2021, 3:18pm UTC](https://community.linx.software/community/t/aramex-rest-example-for-south-african-shipping/520 "2021-02-11T15:18:27Z")
:warning: Please note that this example is specifically for using the REST API provided by Aramex South Africa. For other countries, please contact your Aramex offices for local APIs, or use the international SOAP APIs … [Next page](https://community.linx.software/community/c/howto/5.md?page=1)