tabularDataBySql method

Future<List<Map<String, dynamic>>> tabularDataBySql(
  1. String organizationId,
  2. String query
)

Obtain unified tabular data and metadata, queried with SQL.

// List<Map<String, dynamic>>? _responseData;

 _viam = await Viam.withApiKey(
     dotenv.env['API_KEY_ID'] ?? '',
     dotenv.env['API_KEY'] ?? ''
 );
 final dataClient = _viam.dataClient;

 // Example SQL query
 final sqlQuery = "SELECT * FROM readings LIMIT 5";

 _responseData = await dataClient.tabularDataBySql(
   "<YOUR-ORG-ID>",
   sqlQuery
 );

For more information, see Data Client API.

Implementation

Future<List<Map<String, dynamic>>> tabularDataBySql(String organizationId, String query) async {
  final request = TabularDataBySQLRequest()
    ..organizationId = organizationId
    ..sqlQuery = query;
  final response = await _dataClient.tabularDataBySQL(request);
  return response.rawData.map((e) => BsonCodec.deserialize(BsonBinary.from(e))).toList();
}