You are here Share QuickCSV for other applications to receive data

Share QuickCSV for other applications to receive data

QuickCSV allows creating hosts to share data from this application using HTTP protocol. You just need to do the following steps:

1. Create host
 
+ Go to menu "Commands" -> "Make Host - Share Data"
 
 
+ When the "Share Data" screen appears, click "Start" to create host
 
 
Click on "Start" to share data - Create Host. You may receive a "Windows Security Alert" message. Click "Allow Access" to share.
 
 
 
If the creation is successful, the screen will display the status "Server is running..."
Now, you can use command HTTP-GET to receive data that it is opening.
 
2. Commands to receive data
 
2.1 Get all data
http://localhost:8081/quickcsv?d=[DataType]
DataType can be: json, csv, txt
 
For example:
 
http://localhost:8081/quickcsv?d=json
http://localhost:8081/quickcsv?d=csv
http://localhost:8081/quickcsv?d=txt
 
 
2.1 Get data with filter conditions
 
http://localhost:8081/quickcsv?d=[DataType]&q=[Filter Formula]
 
For example:
Filter field #1 contains value "Africa"
http://localhost:8081/quickcsv?d=json&q=1=Africa
 
Filter field #1 contains value "Africa" ​​and field #4 contains value "Offline"
 
http://localhost:8081/quickcsv?d=json&q=1=Africa,4=Offline
 
 
Software and tools for synthesizing and analyzing data connecting to QuickCSV
 
Microsoft Excel:
 
+ Add-in A-Tools with functions: BS_DATA, BS_JSON, BS_WEB
+ PowerQuery
+ Power BI
+ Excel data retrieval tools,...
 
Excel Online:  function WEBSERVICE
 
Google Sheets: function IMPORTDATA
 
Other applications:
+ Power BI
+ Tableau, ...