I am trying to connect to our online form in an application called weever. We have the url and access key, but I’m unsure how to make the connection and receive all of the data from their server.
What is "odata"?
The OData Protocol is **an application-level protocol for interacting with data via RESTful interfaces. It’s a type of API
Perspective/Ignition have no special client handling for OData. You will need to manually construct the queries you want to issue, with either an HTTP binding, or, more powerfully/flexibly, the system.net.httpClient
function: system.net.httpClient - Ignition User Manual 8.1 - Ignition Documentation
Keep in mind that both an HTTP binding and system.net.httpClient
will be issuing requests from the Gateway, not your local device running the Perspective session.
Okay one of the details I can’t seem to get much information on is how to put in credentials for the server to respond.
That's largely up to the API you're talking to. OData itself doesn't have much to say about authentication. Do you have a link to any documentation?
No I only have the url link and a access code for my admin account
The link is mainly for power bi but I’m trying to connect it to ignition
You'll have to get some insight into the API. I looked briefly and didn't see anything from Weever that looked very useful. Based on this article: How do I connect to Power BI with an access key?
You likely issue a base request at your "OData URL", and it gives you back meta-information about other resources you can access. Excel/PowerBI wraps that up in nice presentation, but it's likely just a JSON response with a bunch of further hyperlinks.
You could do this with Python/Jython/whatever directly, or use an HTTP-exploration tool like POSTMan, httpie
, etc.
Thank you, I would have as hard of a time if our server was internet connected I could pull directly into our database.
I've got a little way now but get the error Error Exception("api.prod.weeverapps.com"). Do you have any idea of what the issue is the error is vague?
Where/how are you testing? I would focus on testing from something like the script console, so you get the full detail of any errors.
I am testing through the HTTP binding wizard.