Skip to main content
Pigarri
Pigarri
Silver ⭐️
September 16, 2021
Solved

Como tranformar um JSON em varios flow files?

Ex: como gerar através deste Json abaixo e gerar 4 flow files?

[ {
"ID_WA_DESTINATARIO" : "5599999999999",
"DES_MENS_NMO" : "Você está recebendo anexa 1a via de sua fatura.",
"COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcv"
}, {
"ID_WA_DESTINATARIO" : "5599999999999",
"DES_MENS_NMO" : "Você está recebendo anexa 1a via de sua fatura.",
"COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvb"
}, {
"ID_WA_DESTINATARIO" : "5599999999999",
"DES_MENS_NMO" : "Você está recebendo anexa 1a via de sua fatura.",
"COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvc"
}, {
"ID_WA_DESTINATARIO" : "5599999999999",
"DES_MENS_NMO" : "Você está recebendo anexa 1a via de sua fatura.",
"COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvd"
} ]

 

GCaixeta
GCaixetaAnswer
Gold ⭐️
September 17, 2021

Tu vai usar o processor SplitJson e na propriedade "JsonPath Expression" tu vai colocar "$"(sem aspas).

View in thread

3 replies

GCaixeta
GCaixetaAnswer
Gold ⭐️
September 17, 2021

Tu vai usar o processor SplitJson e na propriedade "JsonPath Expression" tu vai colocar "$"(sem aspas).

Translate
    Pigarri
    PigarriAuthor
    Silver ⭐️
    September 17, 2021

    Good, muito obrigado @GCaixeta !!

    Se alguém mais tiver a mesma duvida, segue abaixo como ficou o processor SplitJSON:

    Pigarri_0-1631895538220.png

     

    Translate
      VidyaSargur
      Community Manager
      VidyaSargur
      Community Manager
      September 22, 2021

      English Translation:

      Question: 

      How to transform a JSON into multiple flow files?

      Ex: how to generate through this Json below and generate 4 flow files?

      [ {
      "ID_WA_REcipient" : "5599999999999",
      "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.",
      "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcv"
      }, {
      "ID_WA_REcipient" : "5599999999999",
      "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.",
      "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvb"
      }, {
      "ID_WA_REcipient" : "5599999999999",
      "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.",
      "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvc"
      }, {
      "ID_WA_REcipient" : "5599999999999",
      "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.",
      "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvd"
      }]

       

      Solution

      You will use the SplitJson processor and in the property "JsonPath Expression" you will put "$" (without quotes).

      Translate
      Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
        Terms & ConditionsAccessibility statement