# JSON KIBANA mapeo de campos **URL:** https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525 **Category:** Elastic en Español **Created:** [March 25, 2023, 8:08pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525 "2023-03-25T20:08:43Z") **Posts on this page:** 12 **Page:** 1
### Author: ![Whazaza](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@Whazaza](https://discuss.elastic.co/u/Whazaza) #### Post date: [March 25, 2023, 8:08pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/1 "2023-03-25T20:08:43Z")
Hola buenas tengo un inconveniente con logstash y kibana. Estoy intentado tomar campos de un JSON que lo tomo de un input TCP y lo mando a kibana ahora mi inconveniente es a la hora de generar un filtro en “logstash.conf” para que en el area de “Discover” de kibana pueda ver el indice que cree que en este caso se llama Mirth los Fileds correspondientes a mi JSON. por ejemplo tengo este JSON el mismo es mucho más extenso pero solo me interesa machear los siguientes campos: ```auto { "header" : { "sendingApplicationNs" : "value", "sendingApplicationId" : "value", "sendingApplicationIdType" : "value", "sendingFacilityNs" : "value", "sendingFacilityId" : "value", "receivingApplicationNs" : "value", "receivingApplicationId" : "value", "receivingApplicationIdType" : "value", "receivingFacilityNs" : "value", "receivingFacilityId" : "value", "messageType" : "value", "triggerEvent" : "value", "messageStructure" : "value" } ``` por ejemplo como debería de construir el filtro para tomar "sendingApplicationId" de mi json y que este aparado se cree en mi kibana como un filed y en el ver el valor que corresponde a "sendingApplicationId" de mi JSON para que me lo muestre en kibana. ```auto input { tcp { port => 5041 } } filter { json { source => "message" target => "json_fields" remove_field => ["message"] } mutate { add_field => { "sendingApplicationNs" => "%{[json_fields][header][sendingApplicationNs]}" "sendingApplicationId" => "%{[json_fields][header][sendingApplicationId]}" "sendingApplicationIdType" => "%{[json_fields][header][sendingApplicationIdType]}" "sendingFacilityNs" => "%{[json_fields][header][sendingFacilityNs]}" } } } output { elasticsearch { hosts => ["http://:9200"] user => elastic password => XXXXX index => "mirth" } } ``` intente hacerlo de varias maneras pero no logro este cometido de seleccionar un filed y ver el valor del mismo en kibana para poder graficar ---
### Author: ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp) #### Post date: [March 25, 2023, 8:58pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/2 "2023-03-25T20:58:00Z")
Cual és la salida de Logstash? Necesitas compartir el documento que el Logstash produces. ---
### Author: ![Whazaza](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@Whazaza](https://discuss.elastic.co/u/Whazaza) #### Post date: [March 25, 2023, 9:50pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/3 "2023-03-25T21:50:36Z")
esta es la salida de: logstash-plain.log ```auto [2023-03-25T18:41:52,442][INFO][logstash.runner] Log4j configuration path used is: /etc/logstash/log4j2.properties [2023-03-25T18:41:52,469][INFO][logstash.runner] Starting Logstash {"logstash.version"=>"8.6.2", "jruby.version"=>"jruby 9.3.10.0 (2.6.8) 2023-02-01 107b2e6697 OpenJDK 64-Bit Server VM 17.0.6+10 on 17.0.6+10 +indy +jit [x86_64-linux]"} [2023-03-25T18:41:52,473][INFO][logstash.runner] JVM bootstrap flags: [-Xms1g, -Xmx1g, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djruby.compile.invokedynamic=true, -XX:+HeapDumpOnOutOfMemoryError, -Djava.security.egd=file:/dev/urandom, -Dlog4j2.isThreadContextMapInheritable=true, -Djruby.regexp.interruptible=true, -Djdk.io.File.enableADS=true, --add-exports=jdk.compiler/com.sun.tools.javac.api=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.file=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.parser=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.tree=ALL-UNNAMED, --add-exports=jdk.compiler/com.sun.tools.javac.util=ALL-UNNAMED, --add-opens=java.base/java.security=ALL-UNNAMED, --add-opens=java.base/java.io=ALL-UNNAMED, --add-opens=java.base/java.nio.channels=ALL-UNNAMED, --add-opens=java.base/sun.nio.ch=ALL-UNNAMED, --add-opens=java.management/sun.management=ALL-UNNAMED] [2023-03-25T18:41:53,298][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=>9600, :ssl_enabled=>false} [2023-03-25T18:41:53,678][INFO][org.reflections.Reflections] Reflections took 177 ms to scan 1 urls, producing 127 keys and 444 values [2023-03-25T18:41:54,144][INFO][logstash.javapipeline] Pipeline `main` is configured with `pipeline.ecs_compatibility: v8` setting. All plugins in this pipeline will default to `ecs_compatibility => v8` unless explicitly configured otherwise. [2023-03-25T18:41:54,156][INFO][logstash.outputs.elasticsearch][main] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["http://XXXXXXX [2023-03-25T18:41:54,268][INFO][logstash.outputs.elasticsearch][main] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://elastic:xxxxxx@XXXXXXX [2023-03-25T18:41:54,374][WARN][logstash.outputs.elasticsearch][main] Restored connection to ES instance {:url=>"http://elastic:xxxxxx@XXXXXXX [2023-03-25T18:41:54,383][INFO][logstash.outputs.elasticsearch][main] Elasticsearch version determined (8.6.2) {:es_version=>8} [2023-03-25T18:41:54,383][WARN][logstash.outputs.elasticsearch][main] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document _type {:es_version=>8} [2023-03-25T18:41:54,399][INFO][logstash.outputs.elasticsearch][main] Not eligible for data streams because config contains one or more settings that are not compatible with data streams: {"index"=>"mirth"} [2023-03-25T18:41:54,399][INFO][logstash.outputs.elasticsearch][main] Data streams auto configuration (`data_stream => auto` or unset) resolved to `false` [2023-03-25T18:41:54,403][WARN][logstash.outputs.elasticsearch][main] Elasticsearch Output configured with `ecs_compatibility => v8`, which resolved to an UNRELEASED preview of version 8.0.0 of the Elastic Common Schema. Once ECS v8 and an updated release of this plugin are publicly available, you will need to update this plugin to resolve this warning. [2023-03-25T18:41:54,426][INFO][logstash.outputs.elasticsearch][main] Using a default mapping template {:es_version=>8, :ecs_compatibility=>:v8} [2023-03-25T18:41:54,429][INFO][logstash.javapipeline][main] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50, "pipeline.max_inflight"=>500, "pipeline.sources"=>["/etc/logstash/conf.d/logstash-mirth.conf"], :thread=>"#"} [2023-03-25T18:41:55,163][INFO][logstash.javapipeline][main] Pipeline Java execution initialization time {"seconds"=>0.73} [2023-03-25T18:41:55,270][INFO][logstash.javapipeline][main] Pipeline started {"pipeline.id"=>"main"} [2023-03-25T18:41:55,272][INFO][logstash.inputs.tcp][main][19610e66dab306d8304d0d89afb6c7eb8f6a8d15e252c8c3b89fd910dc6b9dd5] Starting tcp input listener {:address=>"0.0.0.0:5140", :ssl_enable=>false} [2023-03-25T18:41:55,285][INFO][logstash.agent] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>[]} [2023-03-25T18:43:14,571][WARN][logstash.filters.json][main][760d1e0432eff631d4ca6fb3cf906f5c7b750c629962011fea2fcf11d6ce25a6] Error parsing json {:source=>"message", :raw=>"\u001C\r", :exception=>#} [2023-03-25T18:43:14,569][WARN][logstash.filters.json][main][760d1e0432eff631d4ca6fb3cf906f5c7b750c629962011fea2fcf11d6ce25a6] Error parsing json {:source=>"message", :raw=>"\v{\"header\":{\"sendingApplicationNs\":\"XXXXX\",\"sendingApplicationId\":null,\"sendingApplicationIdType\":null,\"sendingFacilityNs\":\"32287\",\"sendingFacilityId\":null,\"receivingApplicationNs\":null,\"receivingApplicationId\":null,\"receivingApplicationIdType\":null,\"receivingFacilityNs\":\"32287\",\"receivingFacilityId\":null,\"messageType\":null,\"triggerEvent\":null,\"messageStructure\":null},\"eventType\":null,\"recordedDateTime\":null,\"eventReasonCode\":null,\"tenantId\":\"sis.XXXXXX.local\",\"port\":443,\"comments\":[{\"code\":null,\"comment\":\"neumonia\",\"coding\":null,\"commentType\":\"DG\"}],\"patient\":{\"pin\":\"94340037\",\"chn\":\"9629667\",\"chnList\":null,\"euid\":null,\"docType\":null,\"authority\":\"1.2.3.4.32287.1\",\"patientType\":null,\"name\":\"ZULMA\",\"surname1\":\"QUINTEROS\",\"surname2\":null,\"birthDateTime\":403585200000,\"sexType\":\"F\",\"raceType\":null,\"addressList\":null,\"familyTelephone\":null,\"emailAddress\":\"\",\"contactTelephone\":null,\"maritalStatus\":null,\"religionType\":null,\"ssn\":null,\"chnMother\":null,\"ethnicGroupType\":null,\"birthCountry\":\"DESC\",\"birthState\":\"DESC\",\"birthTown\":null,\"nacionality\":\"DESC\",\"deathDate\":null,\"updateDate\":null,\"patientIdentified\":null,\"deathIdentificator\":null,\"patientState\":null,\"docsType\":null,\"familyTelephone2\":null,\"emailAddress2\":null,\"emailAddressOther\":null,\"contactTelephone2\":null,\"studentIndicator\":null,\"freeAccountNumber\":null,\"popularNumber\":null,\"pincipalContactName\":null,\"pincipalContactSurname1\":null,\"pincipalContactSurname2\":null,\"patientStatus\":null},\"visit\":{\"transId\":null,\"patientClass\":\"E\",\"pointOfCare\":null,\"room\":\"ClínicaMedica\",\"bed\":null,\"assistanceReason\":\"UR\",\"appointmentId\":null,\"admissionDoctorId\":\"23531299\",\"admissionDoctorSurname1\":\"RAMIREZ\",\"admissionDoctorSurname2\":null,\"admissionDoctorName\":\"GINES JOSE MARIA\",\"admissionSection\":\"URG-GEN\",\"episodeSource\":\"ORG1\",\"episodeNumber\":11573560,\"dischargeDisposition\":null,\"dischargeDestination\":null,\"admitDatetime\":1679768940000,\"dischargeDatetime\":null,\"vipPatient\":false,\"clinicalDischargeServiceCod\":null,\"clinicalDischargeServiceDesc\":null,\"clinicalDischargeSectionCod\":null,\"clinicalDischargeSectionDesc\":null,\"clinicalDischargeCenterCod\":null,\"clinicalDischargeCenterDesc\":null,\"urgDischargeDestCod\":\"\",\"urgDischargeDestDesc\":\"\",\"clinicalDischargeDoctor\":\"\",\"urgDischargeReason\":\"\",\"alternateVisitId\":null,\"alternateVisitType\":null,\"sourceEpisodeId\":null,\"admissionCenterId\":null,\"admissionServiceId\":null,\"admissionSectionId\":null},\"orders\":[{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"GLUCEMIA \",\"num\":null,\"serviceId\":\"660412\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596814,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"UREA (UREMIA) \",\"num\":null,\"serviceId\":\"660902\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596820,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"PERFIL GASES VENOSOS + IONOS + LACTICO\",\"num\":null,\"serviceId\":\"770008\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596826,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"HEMOGRAMA (CITOLOGICO COMPLETO)\",\"num\":null,\"serviceId\":\"660475\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596832,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"CREATININA \",\"num\":null,\"serviceId\":\"660192\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596837,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null}],\"patientInsurance\":[null]}", :exception=>#} ``` ---
### Author: ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp) #### Post date: [March 25, 2023, 10:10pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/4 "2023-03-25T22:10:43Z")
> [@Whazaza](#): > > ```auto > [2023-03-25T18:43:14,569][WARN][logstash.filters.json][main][760d1e0432eff631d4ca6fb3cf906f5c7b750c629962011fea2fcf11d6ce25a6] Error parsing json {:source=>"message", :raw=>"\v{\"header\":{\"sendingApplicationNs\":\"XXXXX\",\"sendingApplicationId\":null,\"sendingApplicationIdType\":null,\"sendingFacilityNs\":\"32287\",\"sendingFacilityId\":null,\"receivingApplicationNs\":null,\"receivingApplicationId\":null,\"receivingApplicationIdType\":null,\"receivingFacilityNs\":\"32287\",\"receivingFacilityId\":null,\"messageType\":null,\"triggerEvent\":null,\"messageStructure\":null},\"eventType\":null,\"recordedDateTime\":null,\"eventReasonCode\":null,\"tenantId\":\"sis.XXXXXX.local\",\"port\":443,\"comments\":[{\"code\":null,\"comment\":\"neumonia\",\"coding\":null,\"commentType\":\"DG\"}],\"patient\":{\"pin\":\"94340037\",\"chn\":\"9629667\",\"chnList\":null,\"euid\":null,\"docType\":null,\"authority\":\"1.2.3.4.32287.1\",\"patientType\":null,\"name\":\"ZULMA\",\"surname1\":\"QUINTEROS\",\"surname2\":null,\"birthDateTime\":403585200000,\"sexType\":\"F\",\"raceType\":null,\"addressList\":null,\"familyTelephone\":null,\"emailAddress\":\"\",\"contactTelephone\":null,\"maritalStatus\":null,\"religionType\":null,\"ssn\":null,\"chnMother\":null,\"ethnicGroupType\":null,\"birthCountry\":\"DESC\",\"birthState\":\"DESC\",\"birthTown\":null,\"nacionality\":\"DESC\",\"deathDate\":null,\"updateDate\":null,\"patientIdentified\":null,\"deathIdentificator\":null,\"patientState\":null,\"docsType\":null,\"familyTelephone2\":null,\"emailAddress2\":null,\"emailAddressOther\":null,\"contactTelephone2\":null,\"studentIndicator\":null,\"freeAccountNumber\":null,\"popularNumber\":null,\"pincipalContactName\":null,\"pincipalContactSurname1\":null,\"pincipalContactSurname2\":null,\"patientStatus\":null},\"visit\":{\"transId\":null,\"patientClass\":\"E\",\"pointOfCare\":null,\"room\":\"ClínicaMedica\",\"bed\":null,\"assistanceReason\":\"UR\",\"appointmentId\":null,\"admissionDoctorId\":\"23531299\",\"admissionDoctorSurname1\":\"RAMIREZ\",\"admissionDoctorSurname2\":null,\"admissionDoctorName\":\"GINES JOSE MARIA\",\"admissionSection\":\"URG-GEN\",\"episodeSource\":\"ORG1\",\"episodeNumber\":11573560,\"dischargeDisposition\":null,\"dischargeDestination\":null,\"admitDatetime\":1679768940000,\"dischargeDatetime\":null,\"vipPatient\":false,\"clinicalDischargeServiceCod\":null,\"clinicalDischargeServiceDesc\":null,\"clinicalDischargeSectionCod\":null,\"clinicalDischargeSectionDesc\":null,\"clinicalDischargeCenterCod\":null,\"clinicalDischargeCenterDesc\":null,\"urgDischargeDestCod\":\"\",\"urgDischargeDestDesc\":\"\",\"clinicalDischargeDoctor\":\"\",\"urgDischargeReason\":\"\",\"alternateVisitId\":null,\"alternateVisitType\":null,\"sourceEpisodeId\":null,\"admissionCenterId\":null,\"admissionServiceId\":null,\"admissionSectionId\":null},\"orders\":[{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"GLUCEMIA \",\"num\":null,\"serviceId\":\"660412\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596814,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"UREA (UREMIA) \",\"num\":null,\"serviceId\":\"660902\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596820,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"PERFIL GASES VENOSOS + IONOS + LACTICO\",\"num\":null,\"serviceId\":\"770008\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596826,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"HEMOGRAMA (CITOLOGICO COMPLETO)\",\"num\":null,\"serviceId\":\"660475\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596832,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10977732\",\"orderNum\":\"10977732\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679713200000,\"providerProfId\":\"23531299\",\"providerProfSurname1\":\"RAMIREZ\",\"providerProfSurname2\":null,\"providerProfName\":\"GINES JOSE MARIA\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"URG-GEN\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"URG\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"E\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10977732\",\"barcode\":null,\"serviceText\":\"CREATININA \",\"num\":null,\"serviceId\":\"660192\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Alta\",\"requestDateTime\":1679779596837,\"observationDateTime\":null,\"relevantClinicalInformation\":\"neumonia\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679713200000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null}],\"patientInsurance\":[null]}", :exception=># at [Source: (byte[])"\u000B{"header":{"sendingApplicationNs":"null","sendingApplicationId":null,"sendingApplicationIdType":null,"sendingFacilityNs":"32287","sendingFacilityId":null,"receivingApplicationNs":null,"receivingApplicationId":null,"receivingApplicationIdType":null,"receivingFacilityNs":"32287","receivingFacilityId":null,"messageType":null,"triggerEvent":null,"messageStructure":null},"eventType":null,"recordedDateTime":null,"eventReasonCode":null,"tenantId":"sis.XXXXXX.local","port":443,"comments":[{"code":nul"[truncated 10409 bytes]; line: 1, column: 2]>} > > ``` Tienes un error en su mensaje JSON. El mensaje tiene un carácter no permitido en el principio. > [2023-03-25T18:43:14,569][WARN][logstash.filters.json][main][760d1e0432eff631d4ca6fb3cf906f5c7b750c629962011fea2fcf11d6ce25a6] Error parsing json {:source=\>"message", :raw=\>" **\v** {"header": ¿Qué está enviando ese mensaje? Necesitas validar en la origen del mensaje. ---
### Author: ![Whazaza](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@Whazaza](https://discuss.elastic.co/u/Whazaza) #### Post date: [March 25, 2023, 10:50pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/5 "2023-03-25T22:50:11Z")
Listo ya cambie el Encoding a UTF-8 y no tengo mas el error creo los Fileds bien pero el dato no es correcto : Por ejemplo: sendingApplicationNs me deberia de mostrar solo como resultado en este caso EHCOS pero cuando lo busco no me trae nada (como la imagen 2) ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/4/646312cdf4863b67780219a0523baab2745678e4.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/7/377067c7b3025f37da19785f98e954ef2361aa3e.png) y la idea es que trabaje como este otro index que tiene un filed que se llama db\_status y me trae el valor que contetiene el mismo: ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/e/de61f0344ed6d65d19d707d502d2faee599e38c1.png) este es el contenido que veo: ```auto { "@timestamp": [ "2023-03-25T21:43:14.462Z" ], "@version": [ "1" ], "@version.keyword": [ "1" ], "event.original": [ "\u001c\r" ], "event.original.keyword": [ "\u001c\r" ], "message": [ "\u001c\r" ], "message.keyword": [ "\u001c\r" ], "sendingApplicationId": [ "%{[json_fields][header][sendingApplicationId]}" ], "sendingApplicationId.keyword": [ "%{[json_fields][header][sendingApplicationId]}" ], "sendingApplicationIdType": [ "%{[json_fields][header][sendingApplicationIdType]}" ], "sendingApplicationIdType.keyword": [ "%{[json_fields][header][sendingApplicationIdType]}" ], "sendingApplicationNs": [ "%{[json_fields][header][sendingApplicationNs]}" ], "sendingApplicationNs.keyword": [ "%{[json_fields][header][sendingApplicationNs]}" ], "sendingFacilityNs": [ "%{[json_fields][header][sendingFacilityNs]}" ], "sendingFacilityNs.keyword": [ "%{[json_fields][header][sendingFacilityNs]}" ], "tags": [ "_jsonparsefailure" ], "tags.keyword": [ "_jsonparsefailure" ], "_id": "-465GocBs6xamz0nwADY", "_index": "mirth", "_score": 0.05715841 } ``` ---
### Author: ![Whazaza](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@Whazaza](https://discuss.elastic.co/u/Whazaza) #### Post date: [March 27, 2023, 2:33pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/6 "2023-03-27T14:33:06Z")
Hola @leandrojmp me podría explicar como tomar los campos que menciono por que intente nuevamente y no lo logro hacer con tal de entender como se hace uno armo el resto pero ese es el tema no consigo de ninguna manera el resultado que busco ---
### Author: ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp) #### Post date: [March 27, 2023, 3:19pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/7 "2023-03-27T15:19:26Z")
> [@Whazaza](#): > > ```auto > "message": [ > "\u001c\r" > ] > > ``` Esta es el mensaje que estas recibiendo, esto no es una mensaje json valida, tienes algo que estás enviando estas mensajes. No está claro cuál es su problema ahora, usted a compartido dos mensajes diferentes, una es un json válido y la otra no es un json válido. ---
### Author: ![Whazaza](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@Whazaza](https://discuss.elastic.co/u/Whazaza) #### Post date: [March 27, 2023, 4:15pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/8 "2023-03-27T16:15:35Z")
Pregunta independientemente del JSON en correcta la configuración de mi filtro para lograr el cometido que quiero ? Que básicamente es mapear un dato del json y obtener su valor asi como muestro con el ejemplo de de\_status ? ---
### Author: ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp) #### Post date: [March 27, 2023, 4:37pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/9 "2023-03-27T16:37:47Z")
Necesitas compartir el mensaje completa que tienes en Elasticsearch y Kibana, una mensaje onde tienes el campo `sendingApplicationNs`. Parece que su filtro `json` no funciona, en la imagen que has compartido el campo `sendingApplicationNs` tienes el valor de `%{[json_fields][header][sendingApplicationNs]}` en una de las mensajes. ---
### Author: ![Whazaza](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@Whazaza](https://discuss.elastic.co/u/Whazaza) #### Post date: [March 27, 2023, 5:05pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/10 "2023-03-27T17:05:14Z")
Ese es el mensaje completo: ```auto { "message": [ "\u000b{\"header\":{\"sendingApplicationNs\":\"EHCOS\",\"sendingApplicationId\":null,\"sendingApplicationIdType\":null,\"sendingFacilityNs\":\"32287\",\"sendingFacilityId\":null,\"receivingApplicationNs\":null,\"receivingApplicationId\":null,\"receivingApplicationIdType\":null,\"receivingFacilityNs\":\"32287\",\"receivingFacilityId\":null,\"messageType\":null,\"triggerEvent\":null,\"messageStructure\":null},\"eventType\":null,\"recordedDateTime\":null,\"eventReasonCode\":null,\"tenantId\":\"sis.cordoba.local\",\"port\":443,\"comments\":[{\"code\":null,\"comment\":\"CANCER DE PRÓSTATA\",\"coding\":null,\"commentType\":\"DG\"}],\"patient\":{\"pin\":\"7989508\",\"chn\":\"9629590\",\"chnList\":null,\"euid\":null,\"docType\":null,\"authority\":\"1.2.3.4.32287.1\",\"patientType\":null,\"name\":\"PEDRO MARTINIANO\",\"surname1\":\"ALAGASTIN\",\"surname2\":null,\"birthDateTime\":-794523600000,\"sexType\":\"M\",\"raceType\":null,\"addressList\":null,\"familyTelephone\":null,\"emailAddress\":\"\",\"contactTelephone\":null,\"maritalStatus\":null,\"religionType\":null,\"ssn\":null,\"chnMother\":null,\"ethnicGroupType\":null,\"birthCountry\":\"DESC\",\"birthState\":\"DESC\",\"birthTown\":null,\"nacionality\":\"DESC\",\"deathDate\":null,\"updateDate\":null,\"patientIdentified\":null,\"deathIdentificator\":null,\"patientState\":null,\"docsType\":null,\"familyTelephone2\":null,\"emailAddress2\":null,\"emailAddressOther\":null,\"contactTelephone2\":null,\"studentIndicator\":null,\"freeAccountNumber\":null,\"popularNumber\":null,\"pincipalContactName\":null,\"pincipalContactSurname1\":null,\"pincipalContactSurname2\":null,\"patientStatus\":null},\"visit\":{\"transId\":null,\"patientClass\":\"I\",\"pointOfCare\":\"Cirugía General\",\"room\":\"Hab_08\",\"bed\":\"08_A\",\"assistanceReason\":\"inputFromUrg\",\"appointmentId\":null,\"admissionDoctorId\":null,\"admissionDoctorSurname1\":null,\"admissionDoctorSurname2\":null,\"admissionDoctorName\":null,\"admissionSection\":\"Clínica Médica\",\"episodeSource\":\"ORG3\",\"episodeNumber\":11573816,\"dischargeDisposition\":null,\"dischargeDestination\":null,\"admitDatetime\":1679815887994,\"dischargeDatetime\":null,\"vipPatient\":false,\"clinicalDischargeServiceCod\":null,\"clinicalDischargeServiceDesc\":null,\"clinicalDischargeSectionCod\":null,\"clinicalDischargeSectionDesc\":null,\"clinicalDischargeCenterCod\":null,\"clinicalDischargeCenterDesc\":null,\"urgDischargeDestCod\":null,\"urgDischargeDestDesc\":null,\"clinicalDischargeDoctor\":\"\",\"urgDischargeReason\":null,\"alternateVisitId\":null,\"alternateVisitType\":null,\"sourceEpisodeId\":null,\"admissionCenterId\":null,\"admissionServiceId\":null,\"admissionSectionId\":null},\"orders\":[{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10982172\",\"orderNum\":\"10982172\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679972400000,\"providerProfId\":\"26615985\",\"providerProfSurname1\":\"PANERO\",\"providerProfSurname2\":null,\"providerProfName\":\" Natalia Maria\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"Clínica Médica\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"SVCLIMED\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"I\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10982172\",\"barcode\":null,\"serviceText\":\"ANTÍGENO PROSTÁTICO ESPECÍFICO TOTAL (PSA) \",\"num\":null,\"serviceId\":\"661000\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Media\",\"requestDateTime\":1679935536364,\"observationDateTime\":null,\"relevantClinicalInformation\":\"CANCER DE PRÓSTATA\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679972400000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10982172\",\"orderNum\":\"10982172\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679972400000,\"providerProfId\":\"26615985\",\"providerProfSurname1\":\"PANERO\",\"providerProfSurname2\":null,\"providerProfName\":\" Natalia Maria\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"Clínica Médica\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"SVCLIMED\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"I\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10982172\",\"barcode\":null,\"serviceText\":\"HIV CON TEST RAPIDO \",\"num\":null,\"serviceId\":\"63HIVTR\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Media\",\"requestDateTime\":1679935536372,\"observationDateTime\":null,\"relevantClinicalInformation\":\"CANCER DE PRÓSTATA\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679972400000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null}],\"patientInsurance\":[{\"insuranceCode\":\"500807\",\"folioInsurance\":\"500807\",\"numberInsuranceType\":\"500807 - INSTITUTO NACIONAL DE SERVICIOS SOCIALES PARA JUBILADOS Y PENSIONADOS\",\"planName\":\"PLAN UNICO \"}]}" ], "message.keyword": [ "\u000b{\"header\":{\"sendingApplicationNs\":\"EHCOS\",\"sendingApplicationId\":null,\"sendingApplicationIdType\":null,\"sendingFacilityNs\":\"32287\",\"sendingFacilityId\":null,\"receivingApplicationNs\":null,\"receivingApplicationId\":null,\"receivingApplicationIdType\":null,\"receivingFacilityNs\":\"32287\",\"receivingFacilityId\":null,\"messageType\":null,\"triggerEvent\":null,\"messageStructure\":null},\"eventType\":null,\"recordedDateTime\":null,\"eventReasonCode\":null,\"tenantId\":\"test\",\"port\":443,\"comments\":[{\"code\":null,\"comment\":\"CANCER DE PRÓSTATA\",\"coding\":null,\"commentType\":\"DG\"}],\"patient\":{\"pin\":\"7989508\",\"chn\":\"9629590\",\"chnList\":null,\"euid\":null,\"docType\":null,\"authority\":\"1.2.3.4.32287.1\",\"patientType\":null,\"name\":\"PEDRO MARTINIANO\",\"surname1\":\"ALAGASTIN\",\"surname2\":null,\"birthDateTime\":-794523600000,\"sexType\":\"M\",\"raceType\":null,\"addressList\":null,\"familyTelephone\":null,\"emailAddress\":\"\",\"contactTelephone\":null,\"maritalStatus\":null,\"religionType\":null,\"ssn\":null,\"chnMother\":null,\"ethnicGroupType\":null,\"birthCountry\":\"DESC\",\"birthState\":\"DESC\",\"birthTown\":null,\"nacionality\":\"DESC\",\"deathDate\":null,\"updateDate\":null,\"patientIdentified\":null,\"deathIdentificator\":null,\"patientState\":null,\"docsType\":null,\"familyTelephone2\":null,\"emailAddress2\":null,\"emailAddressOther\":null,\"contactTelephone2\":null,\"studentIndicator\":null,\"freeAccountNumber\":null,\"popularNumber\":null,\"pincipalContactName\":null,\"pincipalContactSurname1\":null,\"pincipalContactSurname2\":null,\"patientStatus\":null},\"visit\":{\"transId\":null,\"patientClass\":\"I\",\"pointOfCare\":\"Cirugía General\",\"room\":\"Hab_08\",\"bed\":\"08_A\",\"assistanceReason\":\"inputFromUrg\",\"appointmentId\":null,\"admissionDoctorId\":null,\"admissionDoctorSurname1\":null,\"admissionDoctorSurname2\":null,\"admissionDoctorName\":null,\"admissionSection\":\"Clínica Médica\",\"episodeSource\":\"ORG3\",\"episodeNumber\":11573816,\"dischargeDisposition\":null,\"dischargeDestination\":null,\"admitDatetime\":1679815887994,\"dischargeDatetime\":null,\"vipPatient\":false,\"clinicalDischargeServiceCod\":null,\"clinicalDischargeServiceDesc\":null,\"clinicalDischargeSectionCod\":null,\"clinicalDischargeSectionDesc\":null,\"clinicalDischargeCenterCod\":null,\"clinicalDischargeCenterDesc\":null,\"urgDischargeDestCod\":null,\"urgDischargeDestDesc\":null,\"clinicalDischargeDoctor\":\"\",\"urgDischargeReason\":null,\"alternateVisitId\":null,\"alternateVisitType\":null,\"sourceEpisodeId\":null,\"admissionCenterId\":null,\"admissionServiceId\":null,\"admissionSectionId\":null},\"orders\":[{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10982172\",\"orderNum\":\"10982172\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679972400000,\"providerProfId\":\"26615985\",\"providerProfSurname1\":\"PANERO\",\"providerProfSurname2\":null,\"providerProfName\":\" Natalia Maria\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"Clínica Médica\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"SVCLIMED\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"I\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10982172\",\"barcode\":null,\"serviceText\":\"ANTÍGENO PROSTÁTICO ESPECÍFICO TOTAL (PSA) \",\"num\":null,\"serviceId\":\"661000\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Media\",\"requestDateTime\":1679935536364,\"observationDateTime\":null,\"relevantClinicalInformation\":\"null\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679972400000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10982172\",\"orderNum\":\"10982172\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679972400000,\"providerProfId\":\"26615985\",\"providerProfSurname1\":\"PANERO\",\"providerProfSurname2\":null,\"providerProfName\":\" Natalia Maria\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"Clínica Médica\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"SVCLIMED\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"I\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10982172\",\"barcode\":null,\"serviceText\":\"null \",\"num\":null,\"serviceId\":\"63HIVTR\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Media\",\"requestDateTime\":1679935536372,\"observationDateTime\":null,\"relevantClinicalInformation\":\"null\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679972400000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null}],\"patientInsurance\":[{\"insuranceCode\":\"500807\",\"folioInsurance\":\"500807\",\"numberInsuranceType\":\"500807 - INSTITUTO NACIONAL DE SERVICIOS SOCIALES PARA JUBILADOS Y PENSIONADOS\",\"planName\":\"PLAN UNICO \"}]}" ], "receivingFacilityNs": [ "%{[header][receivingFacilityNs]}" ], "receivingFacilityNs.keyword": [ "%{[header][receivingFacilityNs]}" ], "sendingApplicationNs": [ "%{[header][sendingApplicationNs]}" ], "sendingApplicationNs.keyword": [ "%{[header][sendingApplicationNs]}" ], "sendingFacilityNs": [ "%{[header][sendingFacilityNs]}" ], "sendingFacilityNs.keyword": [ "%{[header][sendingFacilityNs]}" ], "tags": [ "_jsonparsefailure" ], "tags.keyword": [ "_jsonparsefailure" ], "_id": "UqADJIcBVQHCNpRd5Hi6", "_index": "mirth", "_score": 1 } ``` JSON Oiginal: ```auto type or paste { "header" : { "sendingApplicationNs" : "EHCOS", "sendingApplicationId" : null, "sendingApplicationIdType" : null, "sendingFacilityNs" : "32287", "sendingFacilityId" : null, "receivingApplicationNs" : null, "receivingApplicationId" : null, "receivingApplicationIdType" : null, "receivingFacilityNs" : "32287", "receivingFacilityId" : null, "messageType" : null, "triggerEvent" : null, "messageStructure" : null }, "eventType" : null, "recordedDateTime" : null, "eventReasonCode" : null, "tenantId" : "sis.cordoba.local", "port" : 443, "comments" : [ { "code" : null, "comment" : "null", "coding" : null, "commentType" : "DG" } ], "patient" : { "pin" : "7989508", "chn" : "9629590", "chnList" : null, "euid" : null, "docType" : null, "authority" : "1.2.3.4.32287.1", "patientType" : null, "name" : "PEDRO MARTINIANO", "surname1" : "ALAGASTIN", "surname2" : null, "birthDateTime" : -794523600000, "sexType" : "M", "raceType" : null, "addressList" : null, "familyTelephone" : null, "emailAddress" : "", "contactTelephone" : null, "maritalStatus" : null, "religionType" : null, "ssn" : null, "chnMother" : null, "ethnicGroupType" : null, "birthCountry" : "DESC", "birthState" : "DESC", "birthTown" : null, "nacionality" : "DESC", "deathDate" : null, "updateDate" : null, "patientIdentified" : null, "deathIdentificator" : null, "patientState" : null, "docsType" : null, "familyTelephone2" : null, "emailAddress2" : null, "emailAddressOther" : null, "contactTelephone2" : null, "studentIndicator" : null, "freeAccountNumber" : null, "popularNumber" : null, "pincipalContactName" : null, "pincipalContactSurname1" : null, "pincipalContactSurname2" : null, "patientStatus" : null }, "visit" : { "transId" : null, "patientClass" : "I", "pointOfCare" : "Cirugía General", "room" : "Hab_08", "bed" : "08_A", "assistanceReason" : "inputFromUrg", "appointmentId" : null, "admissionDoctorId" : null, "admissionDoctorSurname1" : null, "admissionDoctorSurname2" : null, "admissionDoctorName" : null, "admissionSection" : "Clínica Médica", "episodeSource" : "ORG3", "episodeNumber" : 11573816, "dischargeDisposition" : null, "dischargeDestination" : null, "admitDatetime" : 1679815887994, "dischargeDatetime" : null, "vipPatient" : false, "clinicalDischargeServiceCod" : null, "clinicalDischargeServiceDesc" : null, "clinicalDischargeSectionCod" : null, "clinicalDischargeSectionDesc" : null, "clinicalDischargeCenterCod" : null, "clinicalDischargeCenterDesc" : null, "urgDischargeDestCod" : null, "urgDischargeDestDesc" : null, "clinicalDischargeDoctor" : "", "urgDischargeReason" : null, "alternateVisitId" : null, "alternateVisitType" : null, "sourceEpisodeId" : null, "admissionCenterId" : null, "admissionServiceId" : null, "admissionSectionId" : null }, "orders" : [ { "commonOrder" : { "orderControl" : "NW", "orderNumber" : "10982172", "orderNum" : "10982172", "barcode" : null, "quantityTiming" : null, "orderStatus" : null, "transDatetime" : 1679972400000, "providerProfId" : "26615985", "providerProfSurname1" : "PANERO", "providerProfSurname2" : null, "providerProfName" : " Natalia Maria", "entLocPointOfCare" : null, "entLocRoom" : "LABORATORIO", "entLocBed" : null, "enteringOrganizationId" : "Clínica Médica", "enteringOrganizationText" : null, "enteringOrganizationCodingSystem" : "M", "addEnteringOrganizationId" : null, "addEnteringOrganizationText" : null, "addEnteringOrganizationCodingSystem" : null, "service" : "SVCLIMED", "organizationName" : "SEDESA", "facility" : null, "organizationId" : "SEDESA", "orderType" : "I", "parentalServiceId" : null, "parentalServiceText" : null }, "timingQuantity" : null, "observatioRequest" : { "orderNumber" : "10982172", "barcode" : null, "serviceText" : "ANTÍGENO PROSTÁTICO ESPECÍFICO TOTAL (PSA) ", "num" : null, "serviceId" : "661000", "alternateServiceId" : "Laboratorio", "alternateServiceText" : "LABORATORIO", "organization" : "SEDESA", "priority" : "Media", "requestDateTime" : 1679935536364, "observationDateTime" : null, "relevantClinicalInformation" : null", "specimenSource" : null, "orderingProviderId" : null, "orderingProviderSurname1" : null, "orderingProviderSurname2" : null, "orderingProviderName" : null, "fillerField1" : null, "timeRelease" : null, "diagnosticServSectId" : null, "changeStatusId" : null, "parentResultIdentifier" : null, "parentResultText" : null, "parentResultCodingSystem" : null, "parentResultSubId" : null, "parentResultObservationResult" : null, "startDateTime" : 1679972400000, "reasonForStudyText" : "", "professionalLicenseRelease" : null, "surnameRelease" : null, "nameRelease" : null, "professionalLicense" : null, "surname" : null, "name" : null }, "observationResults" : null }, { "commonOrder" : { "orderControl" : "NW", "orderNumber" : "10982172", "orderNum" : "10982172", "barcode" : null, "quantityTiming" : null, "orderStatus" : null, "transDatetime" : 1679972400000, "providerProfId" : "26615985", "providerProfSurname1" : "PANERO", "providerProfSurname2" : null, "providerProfName" : " Natalia Maria", "entLocPointOfCare" : null, "entLocRoom" : "LABORATORIO", "entLocBed" : null, "enteringOrganizationId" : "Clínica Médica", "enteringOrganizationText" : null, "enteringOrganizationCodingSystem" : "M", "addEnteringOrganizationId" : null, "addEnteringOrganizationText" : null, "addEnteringOrganizationCodingSystem" : null, "service" : "SVCLIMED", "organizationName" : "SEDESA", "facility" : null, "organizationId" : "SEDESA", "orderType" : "I", "parentalServiceId" : null, "parentalServiceText" : null }, "timingQuantity" : null, "observatioRequest" : { "orderNumber" : "10982172", "barcode" : null, "serviceText" : "null", "num" : null, "serviceId" : "63HIVTR", "alternateServiceId" : "Laboratorio", "alternateServiceText" : "LABORATORIO", "organization" : "SEDESA", "priority" : "Media", "requestDateTime" : 1679935536372, "observationDateTime" : null, "relevantClinicalInformation" : "CANCER DE PRÓSTATA", "specimenSource" : null, "orderingProviderId" : null, "orderingProviderSurname1" : null, "orderingProviderSurname2" : null, "orderingProviderName" : null, "fillerField1" : null, "timeRelease" : null, "diagnosticServSectId" : null, "changeStatusId" : null, "parentResultIdentifier" : null, "parentResultText" : null, "parentResultCodingSystem" : null, "parentResultSubId" : null, "parentResultObservationResult" : null, "startDateTime" : 1679972400000, "reasonForStudyText" : "", "professionalLicenseRelease" : null, "surnameRelease" : null, "nameRelease" : null, "professionalLicense" : null, "surname" : null, "name" : null }, "observationResults" : null } ], "patientInsurance" : [ { "insuranceCode" : "500807", "folioInsurance" : "500807", "numberInsuranceType" : "500807 - INSTITUTO NACIONAL DE SERVICIOS SOCIALES PARA JUBILADOS Y PENSIONADOS", "planName" : "PLAN UNICO " } ] }code here ``` ---
### Author: ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp) #### Post date: [March 27, 2023, 5:32pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/11 "2023-03-27T17:32:37Z")
> [@Whazaza](#): > > ```auto > "tags": [ > "_jsonparsefailure" > ] > > ``` Tienes un error en el filtro json, es el mismo error desta [mensaje](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/4). > [@Whazaza](#): > > ```auto > "message": [ > "\u000b{\"header\":{\"sendingApplicationNs\":\"EHCOS\",\"sendingApplicationId\":null,\"sendingApplicationIdType\":null,\"sendingFacilityNs\":\"32287\",\"sendingFacilityId\":null,\"receivingApplicationNs\":null,\"receivingApplicationId\":null,\"receivingApplicationIdType\":null,\"receivingFacilityNs\":\"32287\",\"receivingFacilityId\":null,\"messageType\":null,\"triggerEvent\":null,\"messageStructure\":null},\"eventType\":null,\"recordedDateTime\":null,\"eventReasonCode\":null,\"tenantId\":\"sis.cordoba.local\",\"port\":443,\"comments\":[{\"code\":null,\"comment\":\"CANCER DE PRÓSTATA\",\"coding\":null,\"commentType\":\"DG\"}],\"patient\":{\"pin\":\"7989508\",\"chn\":\"9629590\",\"chnList\":null,\"euid\":null,\"docType\":null,\"authority\":\"1.2.3.4.32287.1\",\"patientType\":null,\"name\":\"PEDRO MARTINIANO\",\"surname1\":\"ALAGASTIN\",\"surname2\":null,\"birthDateTime\":-794523600000,\"sexType\":\"M\",\"raceType\":null,\"addressList\":null,\"familyTelephone\":null,\"emailAddress\":\"\",\"contactTelephone\":null,\"maritalStatus\":null,\"religionType\":null,\"ssn\":null,\"chnMother\":null,\"ethnicGroupType\":null,\"birthCountry\":\"DESC\",\"birthState\":\"DESC\",\"birthTown\":null,\"nacionality\":\"DESC\",\"deathDate\":null,\"updateDate\":null,\"patientIdentified\":null,\"deathIdentificator\":null,\"patientState\":null,\"docsType\":null,\"familyTelephone2\":null,\"emailAddress2\":null,\"emailAddressOther\":null,\"contactTelephone2\":null,\"studentIndicator\":null,\"freeAccountNumber\":null,\"popularNumber\":null,\"pincipalContactName\":null,\"pincipalContactSurname1\":null,\"pincipalContactSurname2\":null,\"patientStatus\":null},\"visit\":{\"transId\":null,\"patientClass\":\"I\",\"pointOfCare\":\"Cirugía General\",\"room\":\"Hab_08\",\"bed\":\"08_A\",\"assistanceReason\":\"inputFromUrg\",\"appointmentId\":null,\"admissionDoctorId\":null,\"admissionDoctorSurname1\":null,\"admissionDoctorSurname2\":null,\"admissionDoctorName\":null,\"admissionSection\":\"Clínica Médica\",\"episodeSource\":\"ORG3\",\"episodeNumber\":11573816,\"dischargeDisposition\":null,\"dischargeDestination\":null,\"admitDatetime\":1679815887994,\"dischargeDatetime\":null,\"vipPatient\":false,\"clinicalDischargeServiceCod\":null,\"clinicalDischargeServiceDesc\":null,\"clinicalDischargeSectionCod\":null,\"clinicalDischargeSectionDesc\":null,\"clinicalDischargeCenterCod\":null,\"clinicalDischargeCenterDesc\":null,\"urgDischargeDestCod\":null,\"urgDischargeDestDesc\":null,\"clinicalDischargeDoctor\":\"\",\"urgDischargeReason\":null,\"alternateVisitId\":null,\"alternateVisitType\":null,\"sourceEpisodeId\":null,\"admissionCenterId\":null,\"admissionServiceId\":null,\"admissionSectionId\":null},\"orders\":[{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10982172\",\"orderNum\":\"10982172\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679972400000,\"providerProfId\":\"26615985\",\"providerProfSurname1\":\"PANERO\",\"providerProfSurname2\":null,\"providerProfName\":\" Natalia Maria\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"Clínica Médica\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"SVCLIMED\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"I\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10982172\",\"barcode\":null,\"serviceText\":\"ANTÍGENO PROSTÁTICO ESPECÍFICO TOTAL (PSA) \",\"num\":null,\"serviceId\":\"661000\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Media\",\"requestDateTime\":1679935536364,\"observationDateTime\":null,\"relevantClinicalInformation\":\"CANCER DE PRÓSTATA\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679972400000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null},{\"commonOrder\":{\"orderControl\":\"NW\",\"orderNumber\":\"10982172\",\"orderNum\":\"10982172\",\"barcode\":null,\"quantityTiming\":null,\"orderStatus\":null,\"transDatetime\":1679972400000,\"providerProfId\":\"26615985\",\"providerProfSurname1\":\"PANERO\",\"providerProfSurname2\":null,\"providerProfName\":\" Natalia Maria\",\"entLocPointOfCare\":null,\"entLocRoom\":\"LABORATORIO\",\"entLocBed\":null,\"enteringOrganizationId\":\"Clínica Médica\",\"enteringOrganizationText\":null,\"enteringOrganizationCodingSystem\":\"M\",\"addEnteringOrganizationId\":null,\"addEnteringOrganizationText\":null,\"addEnteringOrganizationCodingSystem\":null,\"service\":\"SVCLIMED\",\"organizationName\":\"SEDESA\",\"facility\":null,\"organizationId\":\"SEDESA\",\"orderType\":\"I\",\"parentalServiceId\":null,\"parentalServiceText\":null},\"timingQuantity\":null,\"observatioRequest\":{\"orderNumber\":\"10982172\",\"barcode\":null,\"serviceText\":\"HIV CON TEST RAPIDO \",\"num\":null,\"serviceId\":\"63HIVTR\",\"alternateServiceId\":\"Laboratorio\",\"alternateServiceText\":\"LABORATORIO\",\"organization\":\"SEDESA\",\"priority\":\"Media\",\"requestDateTime\":1679935536372,\"observationDateTime\":null,\"relevantClinicalInformation\":\"CANCER DE PRÓSTATA\",\"specimenSource\":null,\"orderingProviderId\":null,\"orderingProviderSurname1\":null,\"orderingProviderSurname2\":null,\"orderingProviderName\":null,\"fillerField1\":null,\"timeRelease\":null,\"diagnosticServSectId\":null,\"changeStatusId\":null,\"parentResultIdentifier\":null,\"parentResultText\":null,\"parentResultCodingSystem\":null,\"parentResultSubId\":null,\"parentResultObservationResult\":null,\"startDateTime\":1679972400000,\"reasonForStudyText\":\"\",\"professionalLicenseRelease\":null,\"surnameRelease\":null,\"nameRelease\":null,\"professionalLicense\":null,\"surname\":null,\"name\":null},\"observationResults\":null}],\"patientInsurance\":[{\"insuranceCode\":\"500807\",\"folioInsurance\":\"500807\",\"numberInsuranceType\":\"500807 - INSTITUTO NACIONAL DE SERVICIOS SOCIALES PARA JUBILADOS Y PENSIONADOS\",\"planName\":\"PLAN UNICO \"}]}" > ], > > ``` Tu mensaje no es un Json valido, tienes que validar en la origen del mensaje, no puedea tener estos caracteres _\u000b_ en el inicio. (_Same answer in english because my english is a little better than my spanish._ _You have an error in your message, it is not a valid json, it has some characters in the beginning, so your json filter will not work, you need to check and fix this in the source_) ---
### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system) #### Post date: [April 24, 2023, 5:33pm UTC](https://discuss.elastic.co/t/json-kibana-mapeo-de-campos/328525/12 "2023-04-24T17:33:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.