How to access Web Service

We are using RX 3000 and try to access the web service to get the sensor data, using a procedure from SQL server. I successfully get the data when running the procedure manually. But I need to run the procedure automatically, using the SQL job. When the procedure is run automatically in the job, I always get the truncated JSON data. After spending tens of hours on this issue in vain, I wrote a Visual Basic program and it works as an application, but I need to save the data in the SQL server to analyze it, which is a little complicated. I try to push the Visual Basic function as a DLL (assembly) to SQL server, it fails because the SQL server doesn't like System.Web.Extensions that I use for JSON Serialization, which is necessary to build a POST content. I am looking for any experiences with or any thoughts with the HOBOLink Web services. Any feedbacks will be appreciated.

Comment or Subscribe


 
Comment on this
Credentials (your e-mail address will not be shown publicly)
This screen name is what will publicly represent you as a user.
This email address will not appear to the public. The username field will be used to identify you as a poster..
Image CAPTCHA
Enter the characters shown in the image.
Subscribe to comments