# How To **URL:** https://community.linx.software/community/c/howto/5.md?page=1 [Latest](https://community.linx.software/community/latest.md) · [Categories](https://community.linx.software/community/categories.md) **Page:** 2 --- ## [Getting Exchange Rates with Linx](https://community.linx.software/community/t/getting-exchange-rates-with-linx/353)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [December 4, 2018, 6:27am UTC](https://community.linx.software/community/t/getting-exchange-rates-with-linx/353 "2018-12-04T06:27:26Z")
A question received recently, was how can one get exchange rates using Linx? https://linx.software There are a lot of exchange rate API’s available, some free, some not. For this example, I’m using a free API from the E… --- ## [Pulling Exif data from images and photos](https://community.linx.software/community/t/pulling-exif-data-from-images-and-photos/511)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [January 26, 2021, 7:48am UTC](https://community.linx.software/community/t/pulling-exif-data-from-images-and-photos/511 "2021-01-26T07:48:25Z")
From Wikipedia: Exchangeable image file format (officially Exif , according to JEIDA/JEITA/CIPA specifications) is a standard that specifies the formats for images, sound, and ancillary tags used by digital cameras (in… --- ## [Writing C# in Linx](https://community.linx.software/community/t/writing-c-in-linx/562)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [September 30, 2021, 9:05am UTC](https://community.linx.software/community/t/writing-c-in-linx/562 "2021-09-30T09:05:24Z")
In Linx, sometimes you require functionality that is not built into the platform and need to develop your own custom functionality to achieve the task at hand. Typically you are able to build this functionality using the… --- ## [Base64Url encode and decode](https://community.linx.software/community/t/base64url-encode-and-decode/469)
**Author:** [@gawie](https://community.linx.software/community/u/gawie)\ **Replies:** 5\ **Last updated:** [March 30, 2022, 8:09am UTC](https://community.linx.software/community/t/base64url-encode-and-decode/469 "2022-03-30T08:09:06Z")
I’m seeing more and more Base64Url encoded data being used, especially around JWT tokens. Linx supports Base64 functions in its Expressions but not Base64Url (yet). Luckily it is quite simple to do your own conversion wi… --- ## [Kyriba Integration using Linx](https://community.linx.software/community/t/kyriba-integration-using-linx/579)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [January 26, 2022, 10:47am UTC](https://community.linx.software/community/t/kyriba-integration-using-linx/579 "2022-01-26T10:47:17Z")
Kyriba (www.kyriba.com) is the global leader in cloud treasury and finance solutions, delivering mission-critical capabilities for cash and risk management, payments and working capital solutions. In order to build proc… --- ## [Rounding of Decimal to Int](https://community.linx.software/community/t/rounding-of-decimal-to-int/564)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [November 2, 2021, 8:54am UTC](https://community.linx.software/community/t/rounding-of-decimal-to-int/564 "2021-11-02T08:54:30Z")
An interesting topic to consider, when you’ve got a Decimal, or Double value which you want to convert to an Int, what is your intention? If your value is something like 5.673 and you want to change this to Int, what do… --- ## [Working with GraphQL](https://community.linx.software/community/t/working-with-graphql/563)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [October 12, 2021, 9:04am UTC](https://community.linx.software/community/t/working-with-graphql/563 "2021-10-12T09:04:08Z")
GraphQL Query Introduction The Linx GraphQLQuery function allows you to execute a query against a GraphQL server and takes care of the necessary schema validation, input objects as well as resulting data. GraphQL quer… --- ## [Quick MySQL Setup and test on Linx](https://community.linx.software/community/t/quick-mysql-setup-and-test-on-linx/340)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 8\ **Last updated:** [September 15, 2021, 1:47pm UTC](https://community.linx.software/community/t/quick-mysql-setup-and-test-on-linx/340 "2021-09-15T13:47:12Z")
MySQL is a great database tool if you need a powerful database, but free to use. However, it does take a couple more steps to set it up and get it working on Linx. I have followed these steps to connect to MySQL with Lin… --- ## [Struggling with OAuth 2.0?](https://community.linx.software/community/t/struggling-with-oauth-2-0/551)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [August 5, 2021, 9:21am UTC](https://community.linx.software/community/t/struggling-with-oauth-2-0/551 "2021-08-05T09:21:09Z")
When building integrations with the big 3rd-party service providers such as Google, GitHub or Microsoft, applications require a user to grant it permission to act on the user’s behalf, this involves the OAuth 2.0 Authori… --- ## [Running scripts on Linux using Linx](https://community.linx.software/community/t/running-scripts-on-linux-using-linx/171)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 2\ **Last updated:** [May 20, 2021, 7:15am UTC](https://community.linx.software/community/t/running-scripts-on-linux-using-linx/171 "2021-05-20T07:15:31Z")
Because Linx is a Windows service and application, we tend to think that we can only use it to run and manage Windows servers, however, because we can use the Commandline plugin on Linx, we can easily run tools that can … --- ## [Conditional statements within expressions](https://community.linx.software/community/t/conditional-statements-within-expressions/515)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [February 4, 2021, 12:13pm UTC](https://community.linx.software/community/t/conditional-statements-within-expressions/515 "2021-02-04T12:13:40Z")
In Linx, when making decisions to set values, you typically use a IfElseFNC to create a condition and then using a SetValueFNC you set the value appropriately. Lets use the example of deciding whether or not an integ… --- ## [Running Linx on a Mac (Intel)](https://community.linx.software/community/t/running-linx-on-a-mac-intel/501)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [January 8, 2021, 11:55am UTC](https://community.linx.software/community/t/running-linx-on-a-mac-intel/501 "2021-01-08T11:55:54Z")
Linx Designer is a Windows based application, the Linx Services are dependent on Libraries specifically built for Windows. However, as a Mac user, I always use my Mac Laptop to work on Linx. (This post relates to any Int… --- ## [Using Snowflake with Linx](https://community.linx.software/community/t/using-snowflake-with-linx/488)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [December 3, 2020, 2:59pm UTC](https://community.linx.software/community/t/using-snowflake-with-linx/488 "2020-12-03T14:59:52Z")
Snowflake (https://www.snowflake.com/) is a Large Data Solution for data warehousing, data lakes, data engineering, data science, data application development, and for securely sharing and consuming shared data. Linx, n… --- ## [Extracting response headers](https://community.linx.software/community/t/extracting-response-headers/486)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [December 1, 2020, 2:52pm UTC](https://community.linx.software/community/t/extracting-response-headers/486 "2020-12-01T14:52:16Z")
Extracting response headers When making requests using a CallRESTEndpointFNC , responses are returned along with the ResponseHeaders list in the form of: \[ { "Name":"string", "Value":"string" } \] No… --- ## [Quick hint: Struggling with XML, WSDLs or XSDs?](https://community.linx.software/community/t/quick-hint-struggling-with-xml-wsdls-or-xsds/434)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [December 5, 2019, 6:49am UTC](https://community.linx.software/community/t/quick-hint-struggling-with-xml-wsdls-or-xsds/434 "2019-12-05T06:49:35Z")
When working with XML, WSDL or XSDs you’ll find yourself struggling really quickly due to a lot of interlinking and namespace references. Even though it may not work on complex XML files, one trick I’ve learned, to get … --- ## [Referencing List items](https://community.linx.software/community/t/referencing-list-items/476)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [November 11, 2020, 2:09pm UTC](https://community.linx.software/community/t/referencing-list-items/476 "2020-11-11T14:09:22Z")
Referencing List items When working with a ListTYP , you are able to reference specific items in lists by using the below expression: = mylist\[#index#\].item\_property This #index# refers the position of the item in t… --- ## [Boolean Tips and Tricks](https://community.linx.software/community/t/boolean-tips-and-tricks/475)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [November 10, 2020, 10:06am UTC](https://community.linx.software/community/t/boolean-tips-and-tricks/475 "2020-11-10T10:06:16Z")
This is a short list of learnings I’ve found regarding working with Booleans. By no means is this an exhaustive list, so feel free to add on: What is a Boolean: A Boolean is a variable, which can have only one of 2 val… --- ## [Generate PDF Reports with Linx](https://community.linx.software/community/t/generate-pdf-reports-with-linx/474)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [November 5, 2020, 7:03am UTC](https://community.linx.software/community/t/generate-pdf-reports-with-linx/474 "2020-11-05T07:03:17Z")
A very helpful feature of any system is to be able to automatically generate reports and forward it to users, either via Emails, or on a site for download. There are a lot of technologies available for large report gener… --- ## [Resetting Data fields with Ctrl-0 (Hidden feature)](https://community.linx.software/community/t/resetting-data-fields-with-ctrl-0-hidden-feature/468)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 1\ **Last updated:** [October 28, 2020, 10:07am UTC](https://community.linx.software/community/t/resetting-data-fields-with-ctrl-0-hidden-feature/468 "2020-10-28T10:07:44Z")
When adding data into field, especially complex types, a lot of time one wants to remove a specific entry, and reset the resulting JSON string. As example, here is a Photo object with some data added: In this example… --- ## [JWT Token Verification](https://community.linx.software/community/t/jwt-token-verification/464)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [October 16, 2020, 12:01pm UTC](https://community.linx.software/community/t/jwt-token-verification/464 "2020-10-16T12:01:01Z")
Verify JWT Token When the HTTP Bearer authentication scheme is applied to a RESTHost svc operation, the verification of incoming JWT tokens is implicitly handled by Linx during the security validations . This means to … --- ## [JWT Token Generation](https://community.linx.software/community/t/jwt-token-generation/463)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [October 16, 2020, 12:00pm UTC](https://community.linx.software/community/t/jwt-token-generation/463 "2020-10-16T12:00:30Z")
Implementing Token Generation In order for the HTTP Bearer authentication scheme to operate successfully, you need issue the JWT Tokens using a secret key and a payload containing authentication details. This would typic… --- ## [Linx Benchmark Tool](https://community.linx.software/community/t/linx-benchmark-tool/453)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 1\ **Last updated:** [May 28, 2020, 12:14pm UTC](https://community.linx.software/community/t/linx-benchmark-tool/453 "2020-05-28T12:14:36Z")
In order to help users test Linx or test their system setup, they can use this Linx Benchmark Tool. Please note the terms 'Process' and 'Custom Type' have been depreciated and have been replaced with 'Function' and 'Ty… --- ## [Setting up a test VM machine](https://community.linx.software/community/t/setting-up-a-test-vm-machine/113)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 1\ **Last updated:** [March 5, 2020, 9:10am UTC](https://community.linx.software/community/t/setting-up-a-test-vm-machine/113 "2020-03-05T09:10:28Z")
Starting off with Linx might seem like a daunting task, but the installation is quite easy and quick. You should be able to just download Linx and run install. However, when you work on many different projects, all wit… --- ## [Stored Procedure with Dynamic SQL](https://community.linx.software/community/t/stored-procedure-with-dynamic-sql/433)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 0\ **Last updated:** [November 5, 2019, 9:14am UTC](https://community.linx.software/community/t/stored-procedure-with-dynamic-sql/433 "2019-11-05T09:14:02Z")
Please note that the example below is purely for illustrative purposes. I do not recommend using Dynamic SQL queries in such a way as using normal Linx processes are MUCH simpler. I’m just illustrating a scenario where e… --- ## [Linx Application Server Configuration Management and Common Issues](https://community.linx.software/community/t/linx-application-server-configuration-management-and-common-issues/418)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [May 30, 2019, 9:13am UTC](https://community.linx.software/community/t/linx-application-server-configuration-management-and-common-issues/418 "2019-05-30T09:13:24Z")
Additional Server Configuration To enable Linx Application Server to send server related emails (e.g. password resets) edit the configuration file located at: C:\\Program Files (x86)\\Twenty57 Linx Server 5\\Bin\\Server\\Twe… --- ## [Email Filtering](https://community.linx.software/community/t/email-filtering/407)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [April 24, 2019, 10:26am UTC](https://community.linx.software/community/t/email-filtering/407 "2019-04-24T10:26:41Z")
The Linx Email plugin contains two functions which are ReadEmail and SendEmail respectively. By using the ReadEmail function, you are able to “poll” your target Mail Box and filter out the mail box items by making use of… --- ## [Email Plugin Configuration](https://community.linx.software/community/t/email-plugin-configuration/406)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [April 24, 2019, 10:20am UTC](https://community.linx.software/community/t/email-plugin-configuration/406 "2019-04-24T10:20:47Z")
Using Linx, you are able to integrate with Email applications in order to read and send emails. The Linx Email plugin contains two functions which are ReadEmail and SendEmail respectively. This post will detail how to … --- ## [Reformat XML for a specific use (using XSLT)](https://community.linx.software/community/t/reformat-xml-for-a-specific-use-using-xslt/169)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 3\ **Last updated:** [April 3, 2019, 1:44pm UTC](https://community.linx.software/community/t/reformat-xml-for-a-specific-use-using-xslt/169 "2019-04-03T13:44:27Z")
When using the XMLWriter with Linx, one can create really well-formed XML documents. However, there are different standards of XML documents used in the industry today. For that you need to transform a document to fit in… --- ## [Dynamic Settings](https://community.linx.software/community/t/dynamic-settings/393)
**Author:** [@ronan](https://community.linx.software/community/u/ronan)\ **Replies:** 0\ **Last updated:** [March 29, 2019, 2:43pm UTC](https://community.linx.software/community/t/dynamic-settings/393 "2019-03-29T14:43:51Z")
The $.Settings of a Linx solution are constants or static values, which are available to use throughout the entire solution. What happens in some cases is that a user may have a setting value defined, such as a long stri… --- ## [Change the default Security Certificate to one generated for your implemented URL](https://community.linx.software/community/t/change-the-default-security-certificate-to-one-generated-for-your-implemented-url/199)
**Author:** [@Dawie\_Botes](https://community.linx.software/community/u/Dawie_Botes)\ **Replies:** 1\ **Last updated:** [February 15, 2019, 2:19pm UTC](https://community.linx.software/community/t/change-the-default-security-certificate-to-one-generated-for-your-implemented-url/199 "2019-02-15T14:19:36Z")
Linx 5 comes with a Self-signed Security Certificate which is fine for most implementations and internal installations where trust is assured because you’ve done the Linx installation yourself. However, in some cases you… [Previous page](https://community.linx.software/community/c/howto/5.md) [Next page](https://community.linx.software/community/c/howto/5.md?page=2)