Récupérer des valeurs dans un fichier json en provenance d'un http

Plugins Programmation
1

Bonjour a tous,

Débutant sur Jeedom, je cherche a comprendre pourquoi je ne réussit pas a récupérer des valeurs dasn ce fichier avec le script JSon

exemple du fichier qui m’est retourné par interrogation sous google :

{"date": "2021-03-16 16:48:14", "revenu": {"revenu": 0.0, "épargne": 8.73, "revenu_accu_réel": 181.17, "revenu_accu": 0.0}, "type_entreprise ":" "," power_net ": {" energy_buy_day ": 8.12," energy_sal_day ": 9.26," energy_sal_month ": 46.12," power ": 0.0," state ": 0," energy_buy_month ": 155.54}," about " : "", "cityId": 0, "type": 2, "battery": {"battery_out": 0.28, "soc": "95", "battery_in": 4.49, "power": 280.0, "state" : 2, "capacity": "-"}, "energy_type": 1, "capacity": 4.36, "result": "1", "benchmark_price": 0.17, "is_admin": "1", "sig": "Profitez de votre vie "," uid ": 362634," path ":" http://file.solarman.cn/ "," installation ": 4," power_diagram ": {" status1 ":" "," in_power ": "", "status2": ""}, "currency": {"currencyCode": "EUR", "displayName": "娆 у 厓", "id": 74, "numericCode": "978", "symbol ":" 鈧 "}," société ": [{" company_type ": 1," company_logo3 ":" upload // 20170413 / b_c_logo_1_3.png "," company_logo2 ":" upload // 20170413 / b_c_logo_1_2.png ", "company_logo1": "upload // 20170413 / b_c_logo_1_1.png", "company_id": 1, "company_name": "SolarMAN", "company_basic_path": "http://file.solarman.cn/"},{"company_type": 1, "company_logo3": "upload / 20181023061740 / b_c_logo_61_3.png", "company_logo2": "upload / 20181023061740 / b_c_logo_61_2.png", "company_logo1": "upload / 20181023061740 / b_c_logo_61_2.png", "company_logo1": "upload / 20181023061740 / b_c_logo_61_2.png", "company_logo1": "upload / 20181023061740ng / b_logo1" company_id ": 61," company_name ":" 娣 卞 湷 甯 傞  鑸  柊 鑳 芥 簮 鏈 夐 檺 鍏  徃 "," company_basic_path ":" http://file.solarman.cn/ "}]," state " : 1, "owner_name": "********", "company_id": "", "usage_self": {"rate_month": 0.6283, "rate": 0.7016, "rate_day": 0.4211}, "nikename": "******", "photo": "upload / 20190608 / uid_*******_1559972240.png", "url": "http://www.solarman.cn/?p=373790", "power_out": {"average_hours": 3.13, "energy_accu_real ": 8884.28," update_time ":" 2021-03-16 16:47:05 "," energy_day ": 23.56," time_zone_display_en ":" (UTC + 01: 00) Bruxelles, Copenhague, Madrid, Paris "," rate ":" - "," energy_accu ": 8731.0," power ": 130.0," time_zone ":" Europe / Brussels "," power_list ": [{" time ":" 2021-03-16 00:00:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:05:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:10:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:15:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:20:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:25:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:30:00 ","power ": 0.0}, {" time ":" 2021-03-16 00:35:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:40:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:45:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:50:00 "," power ": 0.0}, {" time ":" 2021-03-16 00:55:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:00:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:05:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:10:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:15:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:20:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:25:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:30:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:35:00 "," power ": 0.0}, {" time ":" 2021-03-16 01: 40:00 "," power ": 0.0}, {" time ":" 2021-03-16 01:45:00 "," power ": 0.0}, {" time ":" 2021-03-16 01: 55:00 "," power ": 0.0}, {" time ":" 2021-03-16 02:00:00 "," power ": 0.0}, {" time ":" 2021-03-16 02: 05:00 "," power ": 0.0}, {" time ":" 2021-03-16 02:10:00 "," power ": 0.0}, {" time ":" 2021-03-16 02: 15:00 "," power ": 0.0}, {" time ":" 2021-03-16 02:20:00 "," power ": 0.0}, {" time ":" 2021-03-16 02: 30:00 "," power ": 0.0}, {" time ":" 2021-03-16 02:35:00 "," power ": 0.0}, {" time ":"2021-03-16 02:40:00", "power": 0.0}, {"time": "2021-03-16 02:45:00", "power": 0.0}, {"time": "2021-03-16 02:50:00", "power": 0.0}, {"time": "2021-03-16 02:55:00", "power": 0.0}, {"time": "2021-03-16 03:00:00", "power": 0.0}, {"time": "2021-03-16 03:05:00", "power": 0.0}, {"time": "2021-03-16 03:10:00", "power": 0.0}, {"time": "2021-03-16 03:15:00", "power": 0.0}, {"time": "2021-03-16 03:20:00", "power": 0.0}, {"time": "2021-03-16 03:25:00", "power": 0.0}, {"time": "2021-03-16 03:30:00", "power": 0.0}, {"time": "2021-03-16 03:35:00", "power": 0.0},{"time": "2021-03-16 03:40:00", "power": 0.0}, {"time": "2021-03-16 03:45:00", "power": 0.0}, {"time": "2021-03-16 03:50:00", "power": 0.0}, {"time": "2021-03-16 03:55:00", "power": 0.0}, {"time": "2021-03-16 04:00:00", "power": 0.0}, {"time": "2021-03-16 04:05:00", "power": 0.0}, {"time": "2021-03-16 04:10:00", "power": 0.0}, {"time": "2021-03-16 04:15:00", "power": 0.0}, {"time": "2021-03-16 04:20:00", "power": 0.0}, {"time": "2021-03-16 04:25:00", "power": 0.0}, {"time": "2021-03-16 04:30:00", "power": 0.0}, {"time": "2021-03-16 04:35:00", "power ": 0.0}, {" time ":" 2021-03-16 04:40:00 "," power ": 0.0}, {" time ":" 2021-03-16 04:45:00 "," power ": 0.0}, {" time ":" 2021-03-16 04:50:00 "," power ": 0.0}, {" time ":" 2021-03-16 04:55:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:00:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:05:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:10:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:15:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:20:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:25:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:30:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:35:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:40:00 "," power ": 0.0}, {" time ":" 2021-03-16 05: 45:00 "," power ": 0.0}, {" time ":" 2021-03-16 05:50:00 "," power ": 0.0}, {" time ":" 2021-03-16 05: 55:00 "," power ": 0.0}, {" time ":" 2021-03-16 06:00:00 "," power ": 0.0}, {" time ":" 2021-03-16 06: 10:00 "," power ": 0.0}, {" time ":" 2021-03-16 06:15:00 "," power ": 0.0}, {" time ":" 2021-03-16 06: 20:00 "," power ": 0.0}, {" time ":" 2021-03-16 06:25:00 "," power ": 0.0}, {" time ":" 2021-03-16 06: 30:00 "," power ": 0.0}, {" time ":" 2021-03-16 06:35:00 "," power ": 0.0}, {" time ":"2021-03-16 06:40:00", "power": 0.0}, {"time": "2021-03-16 06:45:00", "power": 0.0}, {"time": "2021-03-16 06:55:00", "power": 0.0}, {"time": "2021-03-16 07:00:00", "power": 0.0}, {"time": "2021-03-16 07:05:00", "power": 0.0}, {"time": "2021-03-16 07:15:00", "power": 0.0}, {"time": "2021-03-16 07:20:00", "power": 90.0}, {"time": "2021-03-16 07:30:00", "power": 120.0}, {"time": "2021-03-16 07:35:00", "power": 110.0}, {"time": "2021-03-16 07:40:00", "power": 120.0}, {"time": "2021-03-16 07:45:00", "power": 40.0}, {"time": "2021-03-16 07:55:00", "power": 290.0}, {"time": "2021-03-16 08:00:00", "power": 490.0}, {"time": "2021-03-16 08:10:00", "power" : 770.0}, {"time": "2021-03-16 08:15:00", "power": 1500.0}, {"time": "2021-03-16 08:25:00", "power" : 1700.0}, {"time": "2021-03-16 08:30:00", "power": 1880.0}, {"time": "2021-03-16 08:40:00", "power" : 1880.0}, {"time": "2021-03-16 08:45:00", "power": 1930.0}, {"time": "2021-03-16 08:55:00", "power" : 1610.0}, {"time": "2021-03-16 09:00:00", "power": 410.0}, {"time": "2021-03-16 09:05:00", "power" : 2100.0}, {"time": "2021-03-16 09:15:00", "power": 2450.0}, {"time":"2021-03-16 09:20:00", "power": 2610.0}, {"time": "2021-03-16 09:30:00", "power": 2760.0}, {"time": "2021-03-16 09:35:00", "power": 2830.0}, {"time": "2021-03-16 09:45:00", "power": 3160.0}, {"time": "2021-03-16 09:50:00", "power": 1660.0}, {"time": "2021-03-16 10:00:00", "power": 3170.0}, {"time": "2021-03-16 10:05:00", "power": 3230.0}, {"time": "2021-03-16 10:15:00", "power": 1720.0}, {"time": "2021-03-16 10:20:00", "power": 2140.0}, {"time": "2021-03-16 10:25:00", "power": 3080.0}, {"time": "2021-03-16 10:35:00", "power": 3280.0}, {"time": "2021-03-16 10:40:00 "," power ": 3540.0}, {" time ":" 2021-03-16 10:45:00 "," power ": 3610.0}, {" time ":" 2021-03-16 10:55: 00 "," power ": 1440.0}, {" time ":" 2021-03-16 11:05:00 "," power ": 3580.0}, {" time ":" 2021-03-16 11:10: 00 "," power ": 3840.0}, {" time ":" 2021-03-16 11:25:00 "," power ": 3760.0}, {" time ":" 2021-03-16 11:30: 00 "," power ": 3730.0}, {" time ":" 2021-03-16 11:35:00 "," power ": 3810.0}, {" time ":" 2021-03-16 11:45: 00 "," power ": 3450.0}, {" time ":" 2021-03-16 11:50:00 "," power ": 3810.0}, {" time ":" 2021-03-16 11:55: 00 "," power ": 3770.0}, {" time ":" 2021-03-16 12:00:00 ","power ": 3760.0}, {" time ":" 2021-03-16 12:05:00 "," power ": 3760.0}, {" time ":" 2021-03-16 12:10:00 "," power ": 3850.0}, {" time ":" 2021-03-16 12:15:00 "," power ": 3850.0}, {" time ":" 2021-03-16 12:20:00 "," power ": 3890.0}, {" time ":" 2021-03-16 12:25:00 "," power ": 3790.0}, {" time ":" 2021-03-16 12:30:00 "," power ": 3770.0}, {" time ":" 2021-03-16 12:35:00 "," power ": 3850.0}, {" time ":" 2021-03-16 12:40:00 "," power ": 3860.0}, {" time ":" 2021-03-16 12:45:00 "," power ": 3250.0}, {" time ":" 2021-03-16 12:50:00 "," power ": 3890.0}, {" time ":" 2021-03-16 12:55:00 "," power ": 3880.0},{"time": "2021-03-16 13:00:00", "power": 1390.0}, {"time": "2021-03-16 13:05:00", "power": 830.0}, {"time": "2021-03-16 13:10:00", "power": 3950.0}, {"time": "2021-03-16 13:15:00", "power": 3800.0}, {"time": "2021-03-16 13:20:00", "power": 3800.0}, {"time": "2021-03-16 13:25:00", "power": 3750.0}, {"time": "2021-03-16 13:30:00", "power": 3680.0}, {"time": "2021-03-16 13:35:00", "power": 3740.0}, {"time": "2021-03-16 13:40:00", "power": 780.0}, {"time": "2021-03-16 13:45:00", "power": 3770.0}, {"time": "2021-03-16 13:50:00", "power": 3470.0}, {"time": "2021-03-16 13:55:00 "," power ": 3560.0}, {" time ":" 2021-03-16 14:00:00 "," power ": 2850.0}, {" time ":" 2021-03-16 14:05:00 "," power ": 3540.0}, {" time ":" 2021-03-16 14:10:00 "," power ": 1200.0}, {" time ":" 2021-03-16 14:15:00 "," power ": 3480.0}, {" time ":" 2021-03-16 14:20:00 "," power ": 1010.0}, {" time ":" 2021-03-16 14:25:00 "," power ": 1010.0}, {" time ":" 2021-03-16 14:30:00 "," power ": 3200.0}, {" time ":" 2021-03-16 14:35:00 "," power ": 2260.0}, {" time ":" 2021-03-16 14:40:00 "," power ": 3260.0}, {" time ":" 2021-03-16 14:45:00 "," power ": 3090.0}, {" time ":" 2021-03-16 14:50:00 "," power ": 3070.0}, {" time ":" 2021-03-16 14:55:00 "," power ": 2980.0}, {" time ":" 2021-03-16 15:00: 00 "," power ": 3220.0}, {" time ":" 2021-03-16 15:05:00 "," power ": 3220.0}, {" time ":" 2021-03-16 15:10: 00 "," power ": 2970.0}, {" time ":" 2021-03-16 15:15:00 "," power ": 940.0}, {" time ":" 2021-03-16 15:20: 00 "," power ": 940.0}, {" time ":" 2021-03-16 15:25:00 "," power ": 2300.0}, {" time ":" 2021-03-16 15:30: 00 "," power ": 1190.0}, {" time ":" 2021-03-16 15:35:00 "," power ": 2470.0}, {" time ":" 2021-03-16 15:40: 00 "," power ": 2680.0}, {" time ":" 2021-03-16 15:45:00 "," power ": 2790.0}, {"time": "2021-03-16 15:50:00", "power": 1250.0}, {"time": "2021-03-16 15:55:00", "power" : 1350.0}, {"time": "2021-03-16 16:00:00", "power": 1440.0}, {"time": "2021-03-16 16:05:00", "power" : 2320.0}, {"time": "2021-03-16 16:10:00", "power": 1660.0}, {"time": "2021-03-16 16:15:00", "power" : 1420.0}, {"time": "2021-03-16 16:20:00", "power": 640.0}, {"time": "2021-03-16 16:25:00", "power" : 640.0}, {"time": "2021-03-16 16:30:00", "power": 540.0}, {"time": "2021-03-16 16:35:00", "power" : 630.0}, {"time": "2021-03-16 16:40:00", "power": 820.0}, {"time":"2021-03-16 16:45:00", "power": 570.0}, {"time": "2021-03-16 16:50:00", "power": 430.0}, {"time": "2021-03-16 16:55:00", "power": 610.0}, {"time": "2021-03-16 17:00:00", "power": 710.0}, {"time": "2021-03-16 17:05:00", "power": 580.0}, {"time": "2021-03-16 17:10:00", "power": 360.0}, {"time": "2021-03-16 17:15:00", "power": 310.0}, {"time": "2021-03-16 17:20:00", "power": 390.0}, {"time": "2021-03-16 17:25:00", "power": 130.0}, {"time": "2021-03-16 17:30:00", "power": 130.0}, {"time": "2021-03-16 17:35:00", "power": 210.0}, {"time": "2021-03-16 17:40:00","power": 160.0}, {"time": "2021-03-16 17:45:00", "power": 130.0}],

Merci pour votre aide

Cordialement

2

Bonjour

Tu fais comment? Avec le plugin script? Si oui, peux tu montrer la config?

3

@Dfreezze

J’ai modifié votre message cette fois ci
merci d’utiliser cette procédure pour les prochainnes fois

4

non j’utilise le type de script json
je rentre l’adresse HTTP
ensuite je met le nom de la variable dans requête et rien de plus

Merci pour l’aide

5

bonjour olive

désolé

merci

6

dans le plugin script, on peut choisir : type de script, a cette endroit je prends le json

si je prends type script, je ne sais pas écrire un code pour faire un script :frowning:

7

Le json est incorrect. Peut-etre a-t-il souffert lors du copier/coller dans le 1er message suivi de son édition pour le rendre lisible.
image

Refournissez le json

8

comment ?, Olive ne souhaite pas un copié / collé direct
merci pour votre aide

9

En cliquant sur le lien fourni par @olive dans son message, vous avez la procédure.

11

Pas mieux toujours incorrect au même endroit.
Vous avez repris le json « retourné par Google » ?

12

oui, en totalité

13

qd je le charge ds JSONLint, il le met en forme sans erreur

14

Pas pour moi:
image

15

effectivement, j’ai également cette erreur

cela bloque le fichier lorsque l’on recherche une info ?

16

Oui il faut que le json soit correct afin qu’il puisse être décodé. PHP: json_decode - Manual

Vous cherchez quelles infos dans le json?

18

uniquement les infos liée a l’energie
consommation
injection
batterie

ses infos sont ds les 1ere lignes

21

Bonjour @Dfreezze

Le json qui est maintenant correct a cette structure:
image
Avec cette requête:
image
en sauvegardant et en testant la commande, on a bien un résultat.

Je ne comprends pas que ça ne fonctionne qu’avec IE. Le json est généré coté serveur et doit etre identique quelque soit le navigateur.
Peut-être des corrections depuis hier par Solarman :thinking:

23

Bonjour Pty

Merci pour votre aide . cela semble fonctionné

Vraiment un grand merci et super d’aider les ignorants comme moi

A bientôt

24

Salut Dfreezze!

Pourrais-tu me dire quelle URL tu appelle (ou quelle forme) pour avoir ce Json?

J’ai mon token Solarman depuis peu et je galère…

Ton sujet date un peu mais a priori il n’y a pas eu de modif sur l’API depuis.

Merci d’avance :wink:

25

bonjour,
ce sujet m’intéresse beaucoup , j’ai un onduleur solarman mais je ne sais pas comment faire pour avoir un retour des valeurs importante dans jeedom et c’est un gros problème pour moi , pourriez vous donner plus de détails sur la méthode ?
comme la page a appeler ce qu’il faut mettre dans le script … avec des captures d’ecrans !!!
merci pour votre aide