Hello
via un Flow je récupère des informations JSON :
Dans ce JSON il y a un tableau avec des valeurs datées. Je voudrais avoir des conseils pour récupérer chaque valeur du tableau et les enregistrer dans une entité HA pour la bonne date.heure
en sachant que mon refresh de JSON tourne toutes les minutes mais je n’aurais une entrée dans le tableau que toutes les heures.
c’est possible de positionner une valeur pour une date?
Merci
voici le JSON :
{"earningStats":[{"meanReward":0.001046757,"reward":0.001299519,"timestamp":"2021-03-02T19:00:00Z"},{"meanReward":0.001035767,"reward":0.001338243,"timestamp":"2021-03-02T18:00:00Z"},{"meanReward":0.001022018,"reward":0.001515382,"timestamp":"2021-03-02T17:00:00Z"},{"meanReward":0.000998525,"reward":0.001348513,"timestamp":"2021-03-02T16:00:00Z"},{"meanReward":0.000981026,"reward":0.001107575,"timestamp":"2021-03-02T15:00:00Z"},{"meanReward":0.000974365,"reward":0.001126255,"timestamp":"2021-03-02T14:00:00Z"},{"meanReward":0.000965927,"reward":0.000890483,"timestamp":"2021-03-02T13:00:00Z"},{"meanReward":0.000970365,"reward":0.000882537,"timestamp":"2021-03-02T12:00:00Z"},{"meanReward":0.000975854,"reward":0.000943928,"timestamp":"2021-03-02T11:00:00Z"},{"meanReward":0.000977982,"reward":0.000853559,"timestamp":"2021-03-02T10:00:00Z"},{"meanReward":0.00098687,"reward":0.00118771,"timestamp":"2021-03-02T09:00:00Z"},{"meanReward":0.000971421,"reward":0.000617961,"timestamp":"2021-03-02T08:00:00Z"},{"meanReward":0.001000876,"reward":0.000822992,"timestamp":"2021-03-02T07:00:00Z"},{"meanReward":0.001017047,"reward":0.00097782,"timestamp":"2021-03-02T06:00:00Z"},{"meanReward":0.00102097,"reward":0.001207587,"timestamp":"2021-03-02T05:00:00Z"},{"meanReward":0.001000234,"reward":0.000859285,"timestamp":"2021-03-02T04:00:00Z"},{"meanReward":0.001017853,"reward":0.001287631,"timestamp":"2021-03-02T03:00:00Z"},{"meanReward":0.000979314,"reward":0.00093804,"timestamp":"2021-03-02T02:00:00Z"},{"meanReward":0.000986193,"reward":0.000947346,"timestamp":"2021-03-02T01:00:00Z"},{"meanReward":0.000993962,"reward":0.000961552,"timestamp":"2021-03-02T00:00:00Z"},{"meanReward":0.001002065,"reward":0.000945319,"timestamp":"2021-03-01T23:00:00Z"},{"meanReward":0.00102098,"reward":0.000778028,"timestamp":"2021-03-01T22:00:00Z"},{"meanReward":0.001142456,"reward":0.001101891,"timestamp":"2021-03-01T21:00:00Z"},{"meanReward":0.001183022,"reward":0.001183022,"timestamp":"2021-03-01T20:00:00Z"}],"expectedReward24H":0.03440316,"expectedRewardWeek":0.24082212,"pendingPayouts":[],"succeedPayouts":[{"amount":0.120375903,"approveUUID":"2558b2b2-a694-473a-b28c-3e50a892b5f2","coin":"ETH","createdAt":"2021-02-27T07:16:16.052573Z","meta":"{\"req_data\": {\"coin\": \"ETH\", \"amount\": 120375903, \"end_dt\": \"2021-02-27T06:30:00Z\", \"start_dt\": \"2021-02-23T06:30:00Z\", \"approveUUID\": \"2558b2b2-a694-473a-b28c-3e50a892b5f2\", \"user_address\": \"01a89f1e1912e22c692511f7bb897ce221992f03\"}, \"tx_receipt\": {\"gasUsed\": \"0x5208\", \"blockHash\": \"0xef710ff3894b1187222512293342b62f0bc7cb68a60ee37fd88c258567560c81\", \"transactionHash\": \"0xaf43df4ae8d4a99c253a2da66bb35e38ccbc693f03b67447619bec1c11fdbdb6\"}}","status":"succeed","txHash":"0xaf43df4ae8d4a99c253a2da66bb35e38ccbc693f03b67447619bec1c11fdbdb6","txMeta":"{\"nonce\":\"515223\",\"gas\":100000,\"gasUsed\":21000,\"gasPrice\":3000000000,\"blockHash\":\"0xef710ff3894b1187222512293342b62f0bc7cb68a60ee37fd88c258567560c81\"}","type":"miner_reward","updatedAt":"2021-02-27T08:04:22.382112Z","userAddress":"01a89f1e1912e22c692511f7bb897ce221992f03","uuid":"85537791-a11e-4a85-b636-78234d5597b4"}],"totalPaid":0.466393021,"totalUnpaid":0.083646972}