LAU: Extract a field from

[Nevicare 0]

Hi,

I want to extract a specific field from an URL-GET response. How canI do that?

The number 1794 in the example below is the value I want to collect.

That is field nr. 9, when I can use the delimiter "," 

 

My code to get the URL response is:

local http = Net.FHttp("192.168.1.75", 80);
local response = http:GET("/api/v1&limit=1");
fibaro:debug("response.."..response)

 

Then response has the following value:

[DEBUG] 15:46:36: response..[["2020-06-26 15:46:29", 1593179189, 0, 3704.64, 2881.834, 459.547, 1080.007, "P", 1794, 1662, 1778.002]]

 

How can I put this specific field in a variabele?

 

Thanks in advance.

 

Richard

 

[pflugj 13]

Hi

I would try the following:

1st remove ALL unwanted characters from the string like maybe so: 

string.gsub(response ,  "[[" , ""  ) 

Please login or register to see this code.

 

Then use a csv parser to create a table.

like you find here:

Please login or register to see this link.

 

The result would be a table, where you can easily pick value number 9 for example

 

Hope that helps
Cheers
 

 

 

[SmartHomeEddy 814]

5 hours ago, Nevicare said:

Then response has the following value:

[DEBUG] 15:46:36: response..[["2020-06-26 15:46:29",

Please login or register to see this link.

, 0, 3704.64, 2881.834, 459.547, 1080.007, "P", 1794, 1662, 1778.002]]

This looks like the response of a P1 Monitor for measurement of power consumption. If so, there is a VD or Quickapp to extract all data. 
 

or 

 

Edited June 26, 2020 by SmartHomeEddy

[Nevicare 0]

Thanks for you response.

 

@SmartHomeEddy: you are right! I created the Virtual Device. Adjusted it a little bit. It works perfect!

 

 

[SmartHomeEddy 814]

?