# Send csv to elasticsearch cloud error

**URL:** <https://discuss.elastic.co/t/send-csv-to-elasticsearch-cloud-error/157789>\
**Category:** Logstash\
**Created:** [November 21, 2018, 11:31pm UTC](https://discuss.elastic.co/t/send-csv-to-elasticsearch-cloud-error/157789 "2018-11-21T23:31:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mateo](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@mateo](https://discuss.elastic.co/u/mateo)\
**Post date:** [November 21, 2018, 11:31pm UTC](https://discuss.elastic.co/t/send-csv-to-elasticsearch-cloud-error/157789/1 "2018-11-21T23:31:04Z")

</div>

Can somebody help me ? I want to send a csv to elasticsearch cloud but I get an error this is my logstash conf and later the error:

```
    input {
        file {
            path=>"/home/mateo/Documentos/proyectomis/saldosiniciales.csv"
            start_position => "beginning"
            sincedb_path => "/dev/null"
            }

    }
    filter {
        csv {
                    columns => [ "FECHA", "SALDO", "CSUCURSAL", "NSUCURSAL", "COFICINA", "NOFICINA", "ESTATUS", "NESTATUS", "CODIGOCOTABLE", "NCODIGOCONTABLE", "CATEGORIA", "SUBSISTEMA" ,
                            "CGRUPOPRODUCTO", "NGRUPOPRODUCTO", "CPRODUCTO", "NPRODUCTO", "SEGMENTO", "NSEGMENTO"]
                    separator =>"|"
            }
       mutate {convert => ["SALDO", "float"]}
       date {
            match => ["FECHA", "dd/MM/yy"]
            target => "FECHA"
            timezone => "America/Guayaquil"
}
    }
    output {

```

elasticsearch {  
hosts =\> "[https://d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443](https://d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443)"  
user =\> "elastic"  
password =\> "XXXXXXXXX"  
}  
stdout {}  
}

sudo ./bin/logstash -f /home/mateo/Documentos/proyectomis/saldosiniciales.conf  
Sending Logstash logs to /home/mateo/Documentos/logstash-6.5.0/logs which is now configured via log4j2.properties  
[2018-11-21T18:24:12,901][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2018-11-21T18:24:12,999][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.5.0"}  
[2018-11-21T18:24:27,094][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50}  
[2018-11-21T18:24:28,005][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[https://elastic:xxxxxx@d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443/](https://elastic:xxxxxx@d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443/)]}}  
[2018-11-21T18:24:28,046][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[https://elastic:xxxxxx@d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443/](https://elastic:xxxxxx@d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443/), :path=\>"/"}  
[2018-11-21T18:24:30,927][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[https://elastic:xxxxxx@d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443/](https://elastic:xxxxxx@d12d378a254f49c88f0a79f8208bc454.us-west1.gcp.cloud.es.io:443/)"}  
[2018-11-21T18:24:32,379][ERROR][logstash.pipeline] Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"#LogStash::OutputDelegator:0x468ac09c", :error=\>"Unexpected character ('\<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')\n at [Source: (byte)"\<html lang="en"\>\<meta charset="utf-8"\>\<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"\>\<meta name="viewport" content="width=device-width"\>Kibana@font-face {\n font-family: 'Open Sans';\n font-style: normal;\n font-weight: 300;\n src: local('Open Sans Light'), local('OpenSans-Light'),\n url('/ui/fonts/open\_sans/open\_sans\_v15\_latin\_300.woff2') format('woff2'),\n url('/ui/fonts/open\_sans/open\_sans\_v15\_latin\_300.woff') format('woff'),"[truncated 67525 bytes]; line: 1, column: 2]", :thread=\>"#\<Thread:0x1a9dea68 run\>"}  
[2018-11-21T18:24:32,387][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<LogStash::Json::ParserError: Unexpected character ('\<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')  
at [Source: (byte)"Kibana@font-face {  
font-family: 'Open Sans';  
font-style: normal;  
font-weight: 300;  
src: local('Open Sans Light'), local('OpenSans-Light'),  
url('/ui/fonts/open\_sans/open\_sans\_v15\_latin\_300.woff2') format('woff2'),  
url('/ui/fonts/open\_sans/open\_sans\_v15\_latin\_300.woff') format('woff'),"[truncated 67525 bytes]; line: 1, column: 2]\>, :backtrace=\>["/home/mateo/Documentos/logstash-6.5.0/logstash-core/lib/logstash/json.rb:16:in `jruby_load'", "/home/mateo/Documentos/logstash-6.5.0/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.2.1-java/lib/logstash/outputs/elasticsearch/http_client/pool.rb:447:in`get\_es\_version'", "/home/mateo/Documentos/logstash-6.5.0/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.2.1-java/lib/logstash/outputs/elasticsearch/http\_client/pool.rb:249:in `block in healthcheck!'", "org/jruby/RubyHash.java:1343:in`each'", "/home/mateo/Documentos/logstash-6.5.0/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.2.1-java/lib/logstash/outputs/elasticsearch/http\_client/pool.rb:241:in `healthcheck!'", "/home/mateo/Documentos/logstash-6.5.0/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.2.1-java/lib/logstash/outputs/elasticsearch/http_client/pool.rb:341:in`update\_urls'", "/home/mateo/Documentos/logstash-6.5.0/vendor/bundle/jruby/2.3.0/gems/logstash-output-elasticsearch-9.2.1-java/lib/logstash/outputs/elasticsearch/http\_client/pool.rb:71:in `start'", "/home/mateo/Documentos/logstash-6.5.0/vendor/bundle/jruby/2.3.0/gems/logstash-output-

[2018-11-21T18:24:32,419][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil}  
[2018-11-21T18:24:32,845][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

---

<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:** [December 5, 2018, 11:31pm UTC](https://discuss.elastic.co/t/send-csv-to-elasticsearch-cloud-error/157789/2 "2018-12-05T23:31:12Z")

</div>

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