Discussion Board for collaboration on QlikView Scripting.
Is anyone familiar with extracting data via an API?
We have the API key, xml or Json. I've never done this before
We are familiar with API
Are you tryng to load data from third party software into QlikView?
If so what is your datasource software?
Yes its from a thrid party software, we have received the API keys, xml and json codes
We usually connect via OLE db into the client's SQL database
Could we use your tool to extract the data? we are looking at around a million rows of data to be pulled everyday
You did no tell us the third party software name. (URL will help)
"API keys, xml and json codes" that sounds like a web application (like sales force or brightpearl)
Pulling 1 million records per day from it may kill the server