Récupérer le contenu d'une requete HTTP
Récupérer le contenu d'une requete HTTP
Bonjour,
Je souhaiterais extraire (en gras souligné) les réponses du JSON issu d’une requête HTTP; ses données correspondent aux “nom de colonnes et valeurs” d’un classeur Excel à mettre à jour, dans l’étape suivante.
Ci-dessous un exemple de la structure du fichier JSON :
{
“status”:”ok”,
“message”:””,
“data”:{
“id”:”2116″,
“record_number”:”5″,
“form_id”:”103″,
“user_id”:”620″,
“create_time”:”2025-01-06 09:19:35″,
“update_time”:”2025-01-28 11:09:45″,
“update_user_id”:”6330″,
“update_answer_time”:”2025-01-28 12:09:45″,
“start_time”:null,
“end_time”:null,
“direction”:null,
“recipient_id”:null,
“history”:”blabla”,
“form_unique_id”:”5″,
“origin_answer”:”web”,
“answer_time”:”2025-01-06 10:19:25″,
“user_name”:”blabla@mail.com (blabla)”,
“last_name”:”bla”,
“first_name”:”bla”,
“phone”:”+330000000000″,
“email”:”blabla@mail.com”,
“update_user_name”:”blabla@mail.com (blabla)”,
“recipient_name”:””,
“parent_data_id”:null,
“fields”:{
“logo”:{
“value”:”514383567448bebd02a0.png”,
“type”:”fixed_image”,
“hidden”:”false”,
“time”:{
“112514383567448bebd02a0.png”:””
}
},
“date_et_heure1”:{
“value”:”2025-01-06″,
“type”:”datetime”,
“subtype”:”date”,
“hidden”:”true”,
“time”:{
“06/01/2025″:””
}
},
“information_de_mise_a_jour_c”:{
“value”:”Information de mise à jour (Changelog)”,
“type”:”section”,
“hidden”:”false”,
“time”:{
“”:””
}
}
}
}
}Le schema d’exemple :
<pre class=”language-markup”>
{
"type": "object",
"properties": {
"status": {
"type": "string"
},
"message": {
"type": "string"
},
"data": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"record_number": {
"type": "string"
},
"form_id": {
"type": "string"
},
"user_id": {
"type": "string"
},
"create_time": {
"type": "string"
},
"update_time": {
"type": "string"
},
"update_user_id": {
"type": "string"
},
"update_answer_time": {
"type": "string"
},
"start_time": {},
"end_time": {},
"direction": {},
"recipient_id": {},
"history": {
"type": "string"
},
"form_unique_id": {
"type": "string"
},
"origin_answer": {
"type": "string"
},
"answer_time": {
"type": "string"
},
"user_name": {
"type": "string"
},
"last_name": {
"type": "string"
},
"first_name": {
"type": "string"
},
"phone": {
"type": "string"
},
"email": {
"type": "string"
},
"login": {
"type": "string"
},
"update_user_name": {
"type": "string"
},
"recipient_name": {
"type": "string"
},
"parent_data_id": {},
"fields": {
"type": "object",
"properties": {
"logo_tiss": {
"type": "object",
"properties": {
"value": {
"type": "string"
},
"type": {
"type": "string"
},
"hidden": {
"type": "string"
},
"time": {
"type": "object",
"properties": {
"c100905_2024112514383567448bebd02a0.png": {
"type": "string"
}
}
}
}
},
"date_et_heure1": {
"type": "object",
"properties": {
"value": {
"type": "string"
},
"type": {
"type": "string"
},
"subtype": {
"type": "string"
},
"hidden": {
"type": "string"
},
"time": {
"type": "object",
"properties": {
"06/01/2025": {
"type": "string"
}
}
}
}
},
"information_de_mise_a_jour_c": {
"type": "object",
"properties": {
"value": {
"type": "string"
},
"type": {
"type": "string"
},
"hidden": {
"type": "string"
},
"time": {
"type": "object",
"properties": {
"": {
"type": "string"
}
}
}
}
}
}
}
}
}
}
}
Connectez-vous pour répondre.