The best way is to run a request from the admin concole. When we run it, it also provides an executable SQL query. Just copy the request and use it.
About the question: select specific fields from the table. In the Admin console, find the text field "FL". enter the names of the fields you want to receive, comma. Click on the “Fill Request” button. The top right of the SQL will be available.
Query Generated: ...... select? fl = FIELDNAME & indent = on & q =: & wt = json
Sonu Jul 05 '17 at 9:50 a.m. 2017-07-05 09:50
source share