We had a requirement recently to save data from a cRIO to a SQL database on a server via a RESTful API. We were responsible for both the LabVIEW code on the cRIO and the development of a C# RESTful Web API.
The i3 JSON toolkit utilises Variant Attributes (this approach was presented at a MLUG meeting in 2016) as a storage container and therefore allows you to add, delete, set and retrieve data in a really flexible manner. Once the JSON string is obtained from JKI GET function, it can be transformed into i3 JSON format and left in that form for further processing. Similarly, instead of formatting the JSON string ourselves, it is possible to use i3 JSON representation to add all the required data and then transform it into a JSON string to be sent to the Web API via JKI POST function.
Keep an eye out for a follow up post on what we did server side with the Web API. If you’d like to discuss your LabVIEW challenges, either come along to the user group we host or get in touch.