# Ruby filter - How to access some elastic index data from a ruby filter

**URL:** <https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701>\
**Category:** Logstash\
**Created:** [June 20, 2018, 1:25pm UTC](https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701 "2018-06-20T13:25:52Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![akapit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/akapit/32/32490_2.png) [@akapit](https://discuss.elastic.co/u/akapit)\
**Post date:** [June 26, 2018, 11:43am UTC](https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701/21 "2018-06-26T11:43:43Z")

</div>

```
input {
file {
    path => ["/Users/akapit/Downloads/Report.csv"]
    start_position => "beginning"
    sincedb_path => "/dev/null"
}
}

filter {
    csv {
        separator => ","
        columns => ["Company",
	       "Platform",
           "Account",
		….
		..
            "Textbox7"]
    }
    jdbc_streaming {
        jdbc_driver_library => "/Applications/UnityJDBC/mongodb_unityjdbc_full.jar"
        jdbc_driver_class => "mongodb.jdbc.MongoDriver"
        jdbc_connection_string => "jdbc:mongo://localhost:27018/mydb”
        jdbc_user => ""
        jdbc_password => ""
        statement => "select value from app_values where setting = 'rate'"
        target => "rate"
        add_field => {"yeah" => "This is my rate: %{rate}"}
    }
}

output {
    stdout { codec => rubydebug }
    elasticsearch {
        action => "index"
        hosts => ["127.0.0.1:9200"]
        index => “report-%{+MM.dd.YYYY}"
        document_type => "report"
        #document_id => "%{id}"
        workers => 1
    }
}
```

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [June 26, 2018, 12:47pm UTC](https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701/22 "2018-06-26T12:47:37Z")

</div>

That looks like the recommended settings.  
What error are you seeing?

---

<div class="post-metadata">

**Author:** ![akapit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/akapit/32/32490_2.png) [@akapit](https://discuss.elastic.co/u/akapit)\
**Post date:** [June 26, 2018, 12:56pm UTC](https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701/23 "2018-06-26T12:56:40Z")

</div>

Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<Sequel::AdapterNotFound:  
java::mongodb.jdbc.MongoDriver not loaded\>, :backtrace=\>

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 24, 2018, 12:56pm UTC](https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701/24 "2018-07-24T12:56:43Z")

</div>

Closed on July 24, 2018, 12:56pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

[Previous page](https://discuss.elastic.co/t/ruby-filter-how-to-access-some-elastic-index-data-from-a-ruby-filter/136701.md?page=1)