[GitHub] [drill] LYCJeff opened a new issue, #2736: Use some configuration items to specify the parameters as filters that allow them to be passed to headers and post body through SQL dynamically

[GitBox]

LYCJeff opened a new issue, #2736:
URL: https://github.com/apache/drill/issues/2736

   Some APIs require information be sent as a headers or post body dynamically. 
So I'm wondering if we can pass it in through filter statement.
   
   Perhaps we could design it like the params field in connections parameter. 
For example:
   
   {
     "url": "https://api.sunrise-sunset.org/json";,
     "requireTail": false,
     "bodyParams": ["lat", "lng", "date"]
   }
   
   SQL Query:
   SELECT *
   FROM api.sunrise
   WHERE `body.lat` = 36.7201600
     AND `body.lng` = -4.4203400
     AND `body.date` = '2019-10-02';
   
   Then, the post body would be:
   {
      "lat": 36.7201600,
      "lng": -4.4203400,
      "date": "2019-10-02"
      }
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org