How to get historical data about a thing

[kantzow]

Hi!

I want to fetch the historical values of a thing and believe that seriesV2HistoricData is the right function to call. However I am struggling to know what to fill in as property (uuid). I have tried with thing id, thing property id, and something called "user_id" which is returned by thingsV2List

I get this error flutter: {"id":"jl+qqBjn","code":"bad_request","status":400,"detail":"failed to decode request body with content type \"application/x-www-form-urlencoded; charset=utf-8\": is not a valid index for type []uuid.UUID"}

Can anyone help me how to request the historical data of a thing?

[J-M-L]

I've never done it but from the doc it seems you need to send something like this on a unix command line

curl -X POST "https://api2.arduino.cc/iot/v2/series/historic_data" 
-H "Authorization: Bearer YOUR_ACCESS_TOKEN" 
-H "Content-Type: application/json" 
-d '{
   "from": "START_TIMESTAMP",
   "properties": ["PROPERTY_ID1", "PROPERTY_ID2"],
   "to": "END_TIMESTAMP"
}'

(all in one line don't add the new lines, this is just tp make it readable)

you need to provide your access token, the timestamps and properties in a JSON

may be with flutter it could be something like

String apiUrl = "https://api2.arduino.cc/iot/v2/series/historic_data";
String accessToken = "YOUR_ACCESS_TOKEN";

void fetchData() async {
    final response = await http.post(
      Uri.parse(apiUrl),
      headers: {
        "Authorization": "Bearer $accessToken",
        "Content-Type": "application/json",
      },
      body: jsonEncode({
        "from": "START_TIMESTAMP",
        "properties": ["PROPERTY_ID1", "PROPERTY_ID2"],
        "to": "END_TIMESTAMP",
      }),
    );

    if (response.statusCode == 200) {           // Successfully fetched data
      final data = jsonDecode(response.body);
      print(data);
    } else {                                    // Handle error
      print("Error: ${response.statusCode}");
      print("Response: ${response.body}");
    }
  }

[kantzow]

I have tried with thing id and thing pid, e.g.:

  String history = "";
  List<String> properties = [
    "thing id / thing pid",
  ];
  try {
    final response = await http.post(
      Uri.parse("https://api2.arduino.cc/iot/v2/series/historic_data"),
      body: {
        "from": "2023-09-05",
        "properties": json.encode(properties),
        "to": "2023-09-07",
      },
      headers: {"Authorizatoin": "Bearer $arduinoAccessToken"},
    );
    history = response.body;
  } catch (e) {
    print(e);
  }
  return history;

but still get {"id":"KXaV5G48","code":"bad_request","status":400,"detail":"failed to decode request body with content type \"application/x-www-form-urlencoded; charset=utf-8\": is not a valid index for type []uuid.UUID"}

Do you have any clue what I need instead for the property?

[J-M-L]

@kantzow

with content type "application/x-www-form-urlencoded; charset=utf-8":

you use

@kantzow

      headers: {"Authorizatoin": "Bearer $arduinoAccessToken"},

it seems the content type should be application/json according to the documentation you pointed at

hence my suggested

@J-M-L

      headers: {
        "Authorization": "Bearer $accessToken",
        "Content-Type": "application/json",
      },

the properties seems to be UUIDs

[kantzow]

Adding the Content-Type header seems to be solving some issue, although now i get {"id":"RtnAsibk","code":"unauthorized","status":401,"detail":"not authorized"}
Even though I have a valid access token. Do you know what could cause this?

[J-M-L]

did you spell Authorization correctly (you had Authorizatoin)

did you use IDs for these ?

@kantzow

  List<String> properties = [
    "thing id / thing pid",
  ];

[kantzow]

Thanks.. That one was embarrasing. It seems as if I am getting closer. I do not receive any data but I hope playing around with the time will fix it.

[J-M-L]

we have all been there

@kantzow

I do not receive any data

print the full answer, not just the body. you might get extra information.

if you did not provide the right IDs that could be a reason why the answer is empty

[kantzow]

Seems as if this wasn't the function I wanted to query after all

Request sending of historical data of properties by email

So the request is working (why my mail inbox is filled with historical data unintentionally). I will look for some other function.

[J-M-L]

that's what the doc states

seriesV2HistoricData
historic_data series_v2
Request sending of historical data of properties by email

may be you wanted * seriesV2BatchQuery or seriesV2BatchQueryRaw?

[kantzow]

propertiesV2Timeseries seems very promising to being what I want. I now get the historical data. Thanks for all the help!

[J-M-L]

cool

have fun