Has anyone ever used API’s data as inputs in Mitto? The Zuar API Inputs page shows currently under construction.
Not sure how to query data from an API and do the daily update in Mitto? Any of your experience sharing or suggestions will be highly appreciated! Thanks!
Hey @linli!
APIs are a very common source of data for Mitto. Creating a Mitto job to get data from an API really depends on the API you are trying to use. In simple cases, sometimes you can use a File Download job (cURL), which is basically a Command Line Job formatted for this purpose.
In more complex cases you may need to write an custom python script. Zuar also has number of connectors prebuilt and supported. They can be found on this page .
Lastly, we are working on a connector template so that Mitto users can build their own API connectors. This will likely be completed in a couple of months.
What is the API you are trying to use to get data?
Hi Greg,
Did Zuar happen to complete work on that connector template?
I’m using the FDIC API. Documentation can be found here:
https://api.fdic.gov/banks/docs/
I’m currently pulling the data through the API into excel and into Tableau for dashboards. There’s a lot of manual work involved and I’m working on automating it.
What job type would you recommend I use for this API? I was going to attempt the cURL, but wasn’t quite sure how to get started.
I’m also wanting to pull data from Nutanix using its API, the documentation for that one recommends python: Nutanix API User Guide – Nutanix.dev
I appreciate any help/guidance you can provide!
Hey @janicer!
We actually shifting focus into development of a Runner Python job. This job is very versatile and can be used for your exact use cases. It essentially allows you to run any Python. In doing so, you can build in whatever type of authentication is required for your API endpoints. This job can also enable you to write the data directly to your database so that there is no intermediate steps. If the API call returns an excel file, I’d suggest using a pandas and openpyxl to load and transform the data before sending it to the database.
If you don’t see the new Python job on your Add Job page, we will likely need to license it and add it to your instance. There is no additional charge for this. You can create a support ticket and our team can assist you!
GR
I was wondering if that was going to be the case. I’m still learning python, but it definitely sounds like it’ll be simpler if I shift my testing with python into Mitto. I do have the Python job option, I’ll just have to play with it a bit more.
Thanks!
Yes! I believe you still have some professional support hours open. We can certainly help get you started if you’d like!
Feel free to create a ticket 
GR