cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kevint13
Frequent Visitor

Post (HTTP) each line of a JSON

Hello everybody,
I want to retrieve an element from an "Actif (DT)" JSON and post it for each of the lines in HTTP.

I managed to build the JSON array but I block to make an "apply to each" loop ...

Anyone have an idea to create a loop that will retrieve "Actif (DT)" in each of the lines?

Annotation 2020-01-12 204459.jpg

 

Annotation 2020-01-13 161656.jpg

 

Annotation 2020-01-13 161709.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Kevint13 

I just realised my previous schema I provided you was based on the full JSON output and not just the body section. Try this schema instead and let me know if that solves the issue.

 

	{
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "\"Id (DT)\"": {
            "type": "string"
          },
          "\"Actif (DT)\"": {
            "type": "string"
          },
          "\"Fiche MP (DT)\"": {
            "type": "string"
          },
          "\"Gamme d'operation\"": {
            "type": "string"
          },
          "\"Gamme (DT)\"": {
            "type": "string"
          },
          "\"N° fiche MP\"": {
            "type": "string"
          },
          "\"N° Fiche MP de reference\"": {
            "type": "string"
          },
          "\"Date de demande (DT)\"": {
            "type": "string"
          },
          "\"Ancien statut (Hist DT)\"": {
            "type": "string"
          },
          "\"Date objectif/statut si FERME/TERMI (DT)\"": {
            "type": "string"
          },
          "\"Description détaillée remarque probleme (DT)\"": {
            "type": "string"
          },
          "\"Durée réelle (DT)\"": {
            "type": "string"
          },
          "\"Description Unité (DT)\"": {
            "type": "string"
          },
          "\"Imputation (DT)\"": {
            "type": "string"
          },
          "\"Description détaillée probleme (DT)\"": {
            "type": "string"
          },
          "\"Description Sous unité (DT)\"": {
            "type": "string"
          },
          "\"Type Imputation (IM MO DT)\"": {
            "type": "string"
          },
          "\"N° Imputation (IM MO DT)\"": {
            "type": "string"
          },
          "\"Description Actif (DT)\"": {
            "type": "string"
          },
          "\"Date remarque Problème (DT)\"": {
            "type": "string"
          },
          "\"Date du rapport de panne (DT)\"": {
            "type": "string"
          },
          "\"Date clôture (DT)\"": {
            "type": "string"
          },
          "\"Description DI (DT)\"": {
            "type": "string"
          },
          "\"N° DT\"": {
            "type": "string"
          },
          "\"Description (DT)\"": {
            "type": "string"
          },
          "\"Nom-Prénom Responsable (DT)\"": {
            "type": "string"
          },
          "\"Date création (DT)\"": {
            "type": "string"
          },
          "\"Date statut (DT)\"": {
            "type": "string"
          },
          "\"Priorité (DT)\"": {
            "type": "string"
          },
          "\"Type de travail (DT)\"": {
            "type": "string"
          },
          "\"Métier (DT)\"": {
            "type": "string"
          },
          "\"Action par (Equipe) (DT)\"": {
            "type": "string"
          },
          "\"Emplacement (DT)\"": {
            "type": "string"
          },
          "\"Statut (DT)\"": {
            "type": "string"
          },
          "\"Problème (DT)\"": {
            "type": "string"
          },
          "\"Date fin réelle (DT)\"": {
            "type": "string"
          },
          "\"Remarque Problème (DT)\"": {
            "type": "string"
          },
          "\"Date fin (MO DT)\"": {
            "type": "string"
          }
        },
        "required": [
          "\"Id (DT)\"",
          "\"Actif (DT)\"",
          "\"Fiche MP (DT)\"",
          "\"Gamme d'operation\"",
          "\"Gamme (DT)\"",
          "\"N° fiche MP\"",
          "\"N° Fiche MP de reference\"",
          "\"Date de demande (DT)\"",
          "\"Ancien statut (Hist DT)\"",
          "\"Date objectif/statut si FERME/TERMI (DT)\"",
          "\"Description détaillée remarque probleme (DT)\"",
          "\"Durée réelle (DT)\"",
          "\"Description Unité (DT)\"",
          "\"Imputation (DT)\"",
          "\"Description détaillée probleme (DT)\"",
          "\"Description Sous unité (DT)\"",
          "\"Type Imputation (IM MO DT)\"",
          "\"N° Imputation (IM MO DT)\"",
          "\"Description Actif (DT)\"",
          "\"Date remarque Problème (DT)\"",
          "\"Date du rapport de panne (DT)\"",
          "\"Date clôture (DT)\"",
          "\"Description DI (DT)\"",
          "\"N° DT\"",
          "\"Description (DT)\"",
          "\"Nom-Prénom Responsable (DT)\"",
          "\"Date création (DT)\"",
          "\"Date statut (DT)\"",
          "\"Priorité (DT)\"",
          "\"Type de travail (DT)\"",
          "\"Métier (DT)\"",
          "\"Action par (Equipe) (DT)\"",
          "\"Emplacement (DT)\"",
          "\"Statut (DT)\"",
          "\"Problème (DT)\"",
          "\"Date fin réelle (DT)\"",
          "\"Remarque Problème (DT)\"",
          "\"Date fin (MO DT)\""
        ]
      }
    }

 


Did I answer your question? Mark my post as a solution!

Follow me on Twitter at @QG_LeeJHarris

Or on LinkedIn at in/leejharris

View solution in original post

6 REPLIES 6
LeeHarris
Solution Sage
Solution Sage

Hi @Kevint13 

Please can you post a sample of your JSON output in text format and I'll be happy to take a look at this for you.

 


Did I answer your question? Mark my post as a solution!

Follow me on Twitter at @QG_LeeJHarris

Or on LinkedIn at in/leejharris

Hi @LeeHarris,

Here is a copy paste from json :

{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Date":"Sun, 12 Jan 2020 19:43:33 GMT","Server":"Kestrel","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Content-Length":"2930900"},"body":[{"\"Id (DT)\"":"\"32310875\"","\"Actif (DT)\"":"\"LVR105516\"","\"Fiche MP (DT)\"":"\"MPR-63484\"","\"Gamme d'operation\"":"\"CLIM1472076\"","\"Gamme (DT)\"":"\"CLIM1472078\"","\"N° fiche MP\"":"\"MPR-63484\"","\"N° Fiche MP de reference\"":"\"\"","\"Date de demande (DT)\"":"\"2019/10/27 00:00:00\"","\"Ancien statut (Hist DT)\"":"\"APPR\"","\"Date objectif/statut si FERME/TERMI (DT)\"":"\"2019/11/01 00:00:00\"","\"Description détaillée remarque probleme (DT)\"":"\"Entretien Préventif Cassettes du CDC1 rien à signaler<!-- RICH TEXT -->\"","\"Durée réelle (DT)\"":"\"0","\"Description Unité (DT)\"":"35\"","\"Imputation (DT)\"":"\"MATERIELS DIVERS\"","\"Description détaillée probleme (DT)\"":"\"IM-80814\"","\"Description Sous unité (DT)\"":"\"\"","\"Type Imputation (IM MO DT)\"":"\"Centre de Conduite CDC1\"","\"N° Imputation (IM MO DT)\"":"\"PROJECT\"","\"Description Actif (DT)\"":"\"IM-80814\"","\"Date remarque Problème (DT)\"":"\"Ventilo-convecteur CASSETTE\"","\"Date du rapport de panne (DT)\"":"\"2019/11/27 11:12:37\"","\"Date clôture (DT)\"":"\"\"","\"Description DI (DT)\"":"\"\"","\"N° DT\"":"\"\"","\"Description (DT)\"":"\"DT-19-720651\"","\"Nom-Prénom Responsable (DT)\"":"\"Entretien Préventif Cassettes du CDC1\"","\"Date création (DT)\"":"\"Christian (CEGELEC ACTEMIUM) Riat\"","\"Date statut (DT)\"":"\"2019/10/27 00:00:00\"","\"Priorité (DT)\"":"\"2019/11/27 00:00:00\"","\"Type de travail (DT)\"":"\"4\"","\"Métier (DT)\"":"\"TBM\"","\"Action par (Equipe) (DT)\"":"\"CLIMATISATION\"","\"Emplacement (DT)\"":"\"R1NEEIAC\"","\"Statut (DT)\"":"\"CDC1.CLIM.VC34\"","\"Problème (DT)\"":"\"ATTENTESSAI\"","\"Date fin réelle (DT)\"":"\"\"","\"Remarque Problème (DT)\"":"\"2019/11/26 00:00:00\"","\"Date fin (MO DT)\"":"\"CR:\""},{"\"Id (DT)\"":"\"32310875\"","\"Actif (DT)\"":"\"LVR105516\"","\"Fiche MP (DT)\"":"\"MPR-63484\"","\"Gamme d'operation\"":"\"CLIM1472076\"","\"Gamme (DT)\"":"\"CLIM1472078\"","\"N° fiche MP\"":"\"MPR-63484\"","\"N° Fiche MP de reference\"":"\"\"","\"Date de demande (DT)\"":"\"2019/10/27 00:00:00\"","\"Ancien statut (Hist DT)\"":"\"ATTENTESSAI\"","\"Date objectif/statut si FERME/TERMI (DT)\"":"\"2019/11/01 00:00:00\"","\"Description détaillée remarque probleme (DT)\"":"\"Entretien Préventif Cassettes du CDC1 rien à signaler<!-- RICH TEXT -->\"","\"Durée réelle (DT)\"":"\"0","\"Description Unité (DT)\"":"35\"","\"Imputation (DT)\"":"\"MATERIELS DIVERS\"","\"Description détaillée probleme (DT)\"":"\"IM-80814\"","\"Description Sous unité (DT)\"":"\"\"","\"Type Imputation (IM MO DT)\"":"\"Centre de Conduite CDC1\"","\"N° Imputation (IM MO DT)\"":"\"PROJECT\"","\"Description Actif (DT)\"":"\"IM-80814\"","\"Date remarque Problème (DT)\"":"\"Ventilo-convecteur CASSETTE\"","\"Date du rapport de panne (DT)\"":"\"2019/11/27 11:12:37\"","\"Date clôture (DT)\"":"\"\"","\"Description DI (DT)\"":"\"\"","\"N° DT\"":"\"\"","\"Description (DT)\"":"\"DT-19-720651\"","\"Nom-Prénom Responsable (DT)\"":"\"Entretien Préventif Cassettes du CDC1\"","\"Date création (DT)\"":"\"Christian (CEGELEC ACTEMIUM) Riat\"","\"Date statut (DT)\"":"\"2019/10/27 00:00:00\"","\"Priorité (DT)\"":"\"2019/11/27 00:00:00\"","\"Type de travail (DT)\"":"\"4\"","\"Métier (DT)\"":"\"TBM\"","\"Action par (Equipe) (DT)\"":"\"CLIMATISATION\"","\"Emplacement (DT)\"":"\"R1NEEIAC\"","\"Statut (DT)\"":"\"CDC1.CLIM.VC34\"","\"Problème (DT)\"":"\"ATTENTESSAI\"","\"Date fin réelle (DT)\"":"\"\"","\"Remarque Problème (DT)\"":"\"2019/11/26 00:00:00\"","\"Date fin (MO DT)\"":"\"CR:\""},{"\"Id (DT) ...

 

Formatted it looks like this : Annotation 2020-01-14 192105.jpg

 

Hi @Kevint13 

Add a new Parse JSON action to your Flow after you have received the JSON from your Get TOKEN step. Set the input of the Parse JSON action to the body of the Get TOKEN response and then set the schema to the below. For reference, this was generated by pasting in the JSON response as a sample and allowing Flow to generate it automatically.

 

{
  "type": "object",
  "properties": {
    "statusCode": {
      "type": "integer"
    },
    "headers": {
      "type": "object",
      "properties": {
        "Transfer-Encoding": {
          "type": "string"
        },
        "Date": {
          "type": "string"
        },
        "Server": {
          "type": "string"
        },
        "X-Powered-By": {
          "type": "string"
        },
        "Content-Type": {
          "type": "string"
        },
        "Content-Length": {
          "type": "string"
        }
      }
    },
    "body": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "\"Id (DT)\"": {
            "type": "string"
          },
          "\"Actif (DT)\"": {
            "type": "string"
          },
          "\"Fiche MP (DT)\"": {
            "type": "string"
          },
          "\"Gamme d'operation\"": {
            "type": "string"
          },
          "\"Gamme (DT)\"": {
            "type": "string"
          },
          "\"N° fiche MP\"": {
            "type": "string"
          },
          "\"N° Fiche MP de reference\"": {
            "type": "string"
          },
          "\"Date de demande (DT)\"": {
            "type": "string"
          },
          "\"Ancien statut (Hist DT)\"": {
            "type": "string"
          },
          "\"Date objectif/statut si FERME/TERMI (DT)\"": {
            "type": "string"
          },
          "\"Description détaillée remarque probleme (DT)\"": {
            "type": "string"
          },
          "\"Durée réelle (DT)\"": {
            "type": "string"
          },
          "\"Description Unité (DT)\"": {
            "type": "string"
          },
          "\"Imputation (DT)\"": {
            "type": "string"
          },
          "\"Description détaillée probleme (DT)\"": {
            "type": "string"
          },
          "\"Description Sous unité (DT)\"": {
            "type": "string"
          },
          "\"Type Imputation (IM MO DT)\"": {
            "type": "string"
          },
          "\"N° Imputation (IM MO DT)\"": {
            "type": "string"
          },
          "\"Description Actif (DT)\"": {
            "type": "string"
          },
          "\"Date remarque Problème (DT)\"": {
            "type": "string"
          },
          "\"Date du rapport de panne (DT)\"": {
            "type": "string"
          },
          "\"Date clôture (DT)\"": {
            "type": "string"
          },
          "\"Description DI (DT)\"": {
            "type": "string"
          },
          "\"N° DT\"": {
            "type": "string"
          },
          "\"Description (DT)\"": {
            "type": "string"
          },
          "\"Nom-Prénom Responsable (DT)\"": {
            "type": "string"
          },
          "\"Date création (DT)\"": {
            "type": "string"
          },
          "\"Date statut (DT)\"": {
            "type": "string"
          },
          "\"Priorité (DT)\"": {
            "type": "string"
          },
          "\"Type de travail (DT)\"": {
            "type": "string"
          },
          "\"Métier (DT)\"": {
            "type": "string"
          },
          "\"Action par (Equipe) (DT)\"": {
            "type": "string"
          },
          "\"Emplacement (DT)\"": {
            "type": "string"
          },
          "\"Statut (DT)\"": {
            "type": "string"
          },
          "\"Problème (DT)\"": {
            "type": "string"
          },
          "\"Date fin réelle (DT)\"": {
            "type": "string"
          },
          "\"Remarque Problème (DT)\"": {
            "type": "string"
          },
          "\"Date fin (MO DT)\"": {
            "type": "string"
          }
        },
        "required": [
          "\"Id (DT)\"",
          "\"Actif (DT)\"",
          "\"Fiche MP (DT)\"",
          "\"Gamme d'operation\"",
          "\"Gamme (DT)\"",
          "\"N° fiche MP\"",
          "\"N° Fiche MP de reference\"",
          "\"Date de demande (DT)\"",
          "\"Ancien statut (Hist DT)\"",
          "\"Date objectif/statut si FERME/TERMI (DT)\"",
          "\"Description détaillée remarque probleme (DT)\"",
          "\"Durée réelle (DT)\"",
          "\"Description Unité (DT)\"",
          "\"Imputation (DT)\"",
          "\"Description détaillée probleme (DT)\"",
          "\"Description Sous unité (DT)\"",
          "\"Type Imputation (IM MO DT)\"",
          "\"N° Imputation (IM MO DT)\"",
          "\"Description Actif (DT)\"",
          "\"Date remarque Problème (DT)\"",
          "\"Date du rapport de panne (DT)\"",
          "\"Date clôture (DT)\"",
          "\"Description DI (DT)\"",
          "\"N° DT\"",
          "\"Description (DT)\"",
          "\"Nom-Prénom Responsable (DT)\"",
          "\"Date création (DT)\"",
          "\"Date statut (DT)\"",
          "\"Priorité (DT)\"",
          "\"Type de travail (DT)\"",
          "\"Métier (DT)\"",
          "\"Action par (Equipe) (DT)\"",
          "\"Emplacement (DT)\"",
          "\"Statut (DT)\"",
          "\"Problème (DT)\"",
          "\"Date fin réelle (DT)\"",
          "\"Remarque Problème (DT)\"",
          "\"Date fin (MO DT)\""
        ]
      }
    }
  }
}

 

After the Parse JSON step add another action such as a Compose and select the Actif (DT) property from Dynamic Content. Doing this will automatically generate the Apply to Each loop for you.

 

image.png

 

Hope that helps.

 


Did I answer your question? Mark my post as a solution!

Follow me on Twitter at @QG_LeeJHarris

Or on LinkedIn at in/leejharris

hi @LeeHarris ,

Thanks a lot for your answer,
I tried the code and got an error:

[
  {
    "message": "Invalid type. Expected Object but got Array.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "",
    "schemaId": "#",
    "errorType": "type",
    "childErrors": []
  }
]

Annotation 2020-01-15 180623.jpg

 

Hi @Kevint13 

I just realised my previous schema I provided you was based on the full JSON output and not just the body section. Try this schema instead and let me know if that solves the issue.

 

	{
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "\"Id (DT)\"": {
            "type": "string"
          },
          "\"Actif (DT)\"": {
            "type": "string"
          },
          "\"Fiche MP (DT)\"": {
            "type": "string"
          },
          "\"Gamme d'operation\"": {
            "type": "string"
          },
          "\"Gamme (DT)\"": {
            "type": "string"
          },
          "\"N° fiche MP\"": {
            "type": "string"
          },
          "\"N° Fiche MP de reference\"": {
            "type": "string"
          },
          "\"Date de demande (DT)\"": {
            "type": "string"
          },
          "\"Ancien statut (Hist DT)\"": {
            "type": "string"
          },
          "\"Date objectif/statut si FERME/TERMI (DT)\"": {
            "type": "string"
          },
          "\"Description détaillée remarque probleme (DT)\"": {
            "type": "string"
          },
          "\"Durée réelle (DT)\"": {
            "type": "string"
          },
          "\"Description Unité (DT)\"": {
            "type": "string"
          },
          "\"Imputation (DT)\"": {
            "type": "string"
          },
          "\"Description détaillée probleme (DT)\"": {
            "type": "string"
          },
          "\"Description Sous unité (DT)\"": {
            "type": "string"
          },
          "\"Type Imputation (IM MO DT)\"": {
            "type": "string"
          },
          "\"N° Imputation (IM MO DT)\"": {
            "type": "string"
          },
          "\"Description Actif (DT)\"": {
            "type": "string"
          },
          "\"Date remarque Problème (DT)\"": {
            "type": "string"
          },
          "\"Date du rapport de panne (DT)\"": {
            "type": "string"
          },
          "\"Date clôture (DT)\"": {
            "type": "string"
          },
          "\"Description DI (DT)\"": {
            "type": "string"
          },
          "\"N° DT\"": {
            "type": "string"
          },
          "\"Description (DT)\"": {
            "type": "string"
          },
          "\"Nom-Prénom Responsable (DT)\"": {
            "type": "string"
          },
          "\"Date création (DT)\"": {
            "type": "string"
          },
          "\"Date statut (DT)\"": {
            "type": "string"
          },
          "\"Priorité (DT)\"": {
            "type": "string"
          },
          "\"Type de travail (DT)\"": {
            "type": "string"
          },
          "\"Métier (DT)\"": {
            "type": "string"
          },
          "\"Action par (Equipe) (DT)\"": {
            "type": "string"
          },
          "\"Emplacement (DT)\"": {
            "type": "string"
          },
          "\"Statut (DT)\"": {
            "type": "string"
          },
          "\"Problème (DT)\"": {
            "type": "string"
          },
          "\"Date fin réelle (DT)\"": {
            "type": "string"
          },
          "\"Remarque Problème (DT)\"": {
            "type": "string"
          },
          "\"Date fin (MO DT)\"": {
            "type": "string"
          }
        },
        "required": [
          "\"Id (DT)\"",
          "\"Actif (DT)\"",
          "\"Fiche MP (DT)\"",
          "\"Gamme d'operation\"",
          "\"Gamme (DT)\"",
          "\"N° fiche MP\"",
          "\"N° Fiche MP de reference\"",
          "\"Date de demande (DT)\"",
          "\"Ancien statut (Hist DT)\"",
          "\"Date objectif/statut si FERME/TERMI (DT)\"",
          "\"Description détaillée remarque probleme (DT)\"",
          "\"Durée réelle (DT)\"",
          "\"Description Unité (DT)\"",
          "\"Imputation (DT)\"",
          "\"Description détaillée probleme (DT)\"",
          "\"Description Sous unité (DT)\"",
          "\"Type Imputation (IM MO DT)\"",
          "\"N° Imputation (IM MO DT)\"",
          "\"Description Actif (DT)\"",
          "\"Date remarque Problème (DT)\"",
          "\"Date du rapport de panne (DT)\"",
          "\"Date clôture (DT)\"",
          "\"Description DI (DT)\"",
          "\"N° DT\"",
          "\"Description (DT)\"",
          "\"Nom-Prénom Responsable (DT)\"",
          "\"Date création (DT)\"",
          "\"Date statut (DT)\"",
          "\"Priorité (DT)\"",
          "\"Type de travail (DT)\"",
          "\"Métier (DT)\"",
          "\"Action par (Equipe) (DT)\"",
          "\"Emplacement (DT)\"",
          "\"Statut (DT)\"",
          "\"Problème (DT)\"",
          "\"Date fin réelle (DT)\"",
          "\"Remarque Problème (DT)\"",
          "\"Date fin (MO DT)\""
        ]
      }
    }

 


Did I answer your question? Mark my post as a solution!

Follow me on Twitter at @QG_LeeJHarris

Or on LinkedIn at in/leejharris

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,387)