arina-ielchiieva commented on a change in pull request #2062: DRILL-7711: Add data path, parameter filter pushdown to HTTP plugin URL: https://github.com/apache/drill/pull/2062#discussion_r410913427
########## File path: contrib/storage-http/README.md ########## @@ -29,41 +31,193 @@ The required options are: * `timeout`: Sets the response timeout in seconds. Defaults to `0` which is no timeout. * `connections`: This field contains the details for individual connections. See the section *Configuring API Connections for Details*. -You can configure Drill to work behind a corporate proxy. Details are listed below. +You can configure Drill to work behind a corporate proxy. Details are listed below. ### Configuring the API Connections The HTTP Storage plugin allows you to configure multiple APIS which you can query directly from this plugin. To do so, first add a `connections` parameter to the configuration . Next give the connection a name, which will be used in queries. For instance `stockAPI` or `jira`. -The `connection` can accept the following options: -* `url`: The base URL which Drill will query. You should include the ending slash if there are additional arguments which you are passing. -* `method`: The request method. Must be `get` or `post`. Other methods are not allowed and will default to `GET`. -* `headers`: Often APIs will require custom headers as part of the authentication. This field allows you to define key/value pairs which are submitted with the http request -. The format is: +The `connection` can accept the following options. + +#### URL + +`url`: The base URL which Drill will query. + +`requireTail`: Set to `true` if the query must contain an additional part of the service +URL as a table name, `false` if the URL needs no additional suffix other than that +provided by `WHERE` clause filters. (See below.) + +If your service requires parameters, you have three choices. Suppose your connection is called +`myConn`. First, can include them directly in your URL if the parameters a fixed for a given +service: + +```json +url: "https://api.sunrise-sunset.org/json?lat=36.7201600&lng=-4.4203400&date=2019-10-02";, +requireTail: false +``` + +Query your table like this: + +```sql Review comment: Same here and for all other similar cases. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
