# Logstash input Odata /API stream
**URL:** https://discuss.elastic.co/t/logstash-input-odata-api-stream/152120
**Category:** Logstash
**Created:** [October 11, 2018, 7:37pm UTC](https://discuss.elastic.co/t/logstash-input-odata-api-stream/152120 "2018-10-11T19:37:07Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@jawahar](https://discuss.elastic.co/u/jawahar)
#### Post date: [October 11, 2018, 7:37pm UTC](https://discuss.elastic.co/t/logstash-input-odata-api-stream/152120/1 "2018-10-11T19:37:07Z")
I want to use logstach to bring in data from a public OData site or even via a public API.
Like the NYC 311 service requests data stream
do I use an HTTP input, how do I specify the API call to the csv data
[https://data.cityofnewyork.us/resource/fhrw-4uyv.csv](https://data.cityofnewyork.us/resource/fhrw-4uyv.csv)
I can download the file but prefer to not use a static file but rather a live feed such as the on above.
Jawahar
---
### Author:  [@guyboertje](https://discuss.elastic.co/u/guyboertje)
#### Post date: [October 22, 2018, 1:01pm UTC](https://discuss.elastic.co/t/logstash-input-odata-api-stream/152120/2 "2018-10-22T13:01:44Z")
Have a [look at the http\_poller input](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-http_poller.html). It has the limitation that the url query cannot be dynamic using a file or a last\_value like the jdbc input does.
You may be able to use ENV vars in the LS config and an external cron job that runs LS in http\_poller one shot mode.
[https://dev.socrata.com/docs/queries/](https://dev.socrata.com/docs/queries/)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 19, 2018, 1:05pm UTC](https://discuss.elastic.co/t/logstash-input-odata-api-stream/152120/3 "2018-11-19T13:05:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.