Jump to content
We've recently updated our Privacy Statement, available here. ×

How to connect Spotfire to a web page using REST API


Recommended Posts

We've tried to connect Spotfire to this page https://openapi.dev.proveedores.linko.mx/ created with swagger. The goal is to create dashboards in Spotfire with the information in that page. Acoording to a search in support pages, that could be done using a code in IronPython. The most representative exampe that we are trying to implement is the one explained in this link ( https://community.spotfire.com/wiki/ironpython-script-access-data-web-service-using-httpwebrequest-and-parse-returned-json ). In this exampe there is no need to authenticate and the code reads the Jason format containing the information from a table, using the libraries Urllib or Urllib2 in order to consume the web service. Ours is more complex implementation as it requires authentication among other stuff (data format). Has anybody done a similar implementation, or a suggestion regarding how to codify the script to connect to that page It would be easier if Spotfire included Urllib3.
Link to comment
Share on other sites

Using Iron Python script will always be restricted or not as flexible in its implementation. There is no direct API as such for the same.

In order to consume a web service in spotfire, you can use the ODATA connector available in Spotfire. Only odata endpoint url is accepted here. Make sure you are able to see data with that Odata url on the browser.

https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire...

And if it is published as a view instead of web service, then you can also use TIBCO Data Virtualization connector available in Spotfire to connect to TDV and access that view.

https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...