Access Raw Data via API

Question

Hey

I'm wanting to access the ping data of a device.&nbsp; I've not found an example in the v1 API document that shows how to do this. I've tried the below but haven't found what I expect, i.e. a long list of ping + time + result.

&nbsp;

$resourcePath = '/device/devices/465103/devicedatasources/376/data'

$epochseconds = Get-Date (Get-Date).ToUniversalTime() -UFormat %s

$fields = &nbsp;'?start=' + $epochseconds

$url = 'https://' + $company + '.logicmonitor.com/santaba/rest' + $resourcePath + $fields

&nbsp;

Thanks

&nbsp;

sarah_terry · Accepted Answer

@gwengrafana&nbsp;the resource path should be:&nbsp;$resourcePath = &nbsp;'/device/devices/465103/devicedatasources/8252658/data to get data for all instances of the Ping DataSource. The Ping deviceDataSourceId in this case is the&nbsp;8252658.

gwengrafana · Answer

I can see from&nbsp;

$resourcePath = '/setting/datasources'
	$fields = '?filter=displayName:Ping'

That the dataSourceId I am interested in is id = 21

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "id": &nbsp;21,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "description": &nbsp;"",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "group": &nbsp;"",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "appliesTo": &nbsp;"isDevice()",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "technology": &nbsp;"",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "tags": &nbsp;"ping,network",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "name": &nbsp;"Ping",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "displayName": &nbsp;"Ping",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "version": &nbsp;1515163055,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "auditVersion": &nbsp;0,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "hasMultiInstances": &nbsp;false,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "collectInterval": &nbsp;60,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "collectMethod": &nbsp;"ping",

&nbsp;

But when I look at the machine I am interested in, I do not find that id attached, yet in the UI the Ping graph is being filled in.

&nbsp;

sarah_terry · Answer

@gwengrafana&nbsp;there is an example on this page that shows how to get raw data via the API:&nbsp;https://www.logicmonitor.com/support/rest-api-developers-guide/v1/data/get-data/

Getting data for Ping is the same as getting data for any other DataSource, so that example does apply. Your approach looks correct, but make sure you're using the correct Id - you need the deviceDataSource Id, *not* the DataSource Id. /settings/datasources endpoint will only return the Ids of the DataSources in your account, but what you want is the Id of the instantiated Ping DataSource for a given device. If you instead request /device/devices/ID/devicedatasources, you should see Ping in that list with the deviceDataSource id, which can be used in the get data request.

gwengrafana · Answer

Thanks, $resourcePath = '/device/devices/465103/devicedatasources' gives me

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "id": &nbsp;8252658,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "deviceId": &nbsp;465103,
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "dataSourceId": &nbsp;376,

&nbsp;

$resourcePath = '/device/devices/465103/devicedatasources'

$fields = '?filter=dataSourceId:376'

Gives me a slimdowned version of the results. But I am failing to understand deviceDataSourceId as&nbsp;

$resourcePath = &nbsp;'/device/devices/465103/devicedatasources/376/instances

OR

$resourcePath = &nbsp;'/device/devices/465103/devicedatasources/8252658/instances

returns nothing.&nbsp;

&nbsp;

gwengrafana · Answer

Ak okay, so data rather than instances. Thank&nbsp;you, this gives with some data back although seems to have no values but I guess that may be a different issue.

&nbsp;

{
	&nbsp; &nbsp; "dataSourceName": &nbsp;"PingMulti",
	&nbsp; &nbsp; "dataPoints": &nbsp;[
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"avgrtt",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"maxrtt",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"minrtt",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"PingLossPercent",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"recvdpkts",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"sentpkts"
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;],
	&nbsp; &nbsp; "instances": &nbsp;{

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
	}
	&nbsp;

Forum Discussion

Access Raw Data via API

5 Replies

Related Content

PropertySource access via RestAPI

DataSource recording zeroes for non-zero raw responses

365 licenses data?

Data from logs

Complex Groovy DataPoint access to Script/Batchscript output

Recent Discussions

Dashboard Sharing – An Inline Framing Method

2021-12-15 US Office Hours

Live Training - Tuning Datapoints and Alerts - 15th JUNE 2022 - APAC

Live Training - Introduction to Dashboards - 18th MAY 2022 - APAC

2022-05-11- APAC Product Overview -Collectors, Resources/Groups, Dashboards