SWIS API REST/CRUD commands for the World Map

It would be great to be able to add/remove/update world map objects via the API. I have multiple instances where devices are constantly being added and removed and it would be much easier to have the world map automatically updated based on custom properties. This kind of works now with some SQL scripts but is not fully functional (devices close together break the tooltips and require manual intervention in the World Map). For some of these instances there are 500+ different locations and it would be an admin nightmare to fix this individually.

I'm thinking something along the lines of:

AddWorldMapPoint (groups, nodes - add coordinates and location)
RemoveWorldMapPoint (remove based on any of the object properties)
ModifyWorldMapPoint (update coordinates or location name)

Find more posts tagged with

worldwide map

maps

worldwide maps

worldwide_map

worldwide_map npm

groups on worldwide

world map

Status: None

Comments

HerrDoktor

I think most of it is already possible. I will dig out my samples and share them

HerrDoktor

Here's a Snippet out of a larger script where I create a new WorldMapPoint out of a CSV File that is loaded in the variable "$Location" I have latitude and Longitude there. Maybe you can start from here.

I am working on an Update Location part at the moment, once this is finished I will post it here.

if(!$MapPointPresent){

## Get the Coordinates from the Source CSV File ##

$Latitude = [double]$Location.Latitude

$Longitude = [double]$Location.Longitude

## Set the MapPoint Properties for the Group ##

$MapPointProps =@{

## Instance is Orion.Groups it can also be Orion.Node ##

Instance = 'Orion.Groups'

## Here we need the ID of the Group or the Node that we are Adding ##

InstanceID = $GroupID

Latitude = $Latitude

Longitude = $Longitude

}

$newMapPointUri = New-SwisObject $target -EntityType "Orion.WorldMap.Point" -Properties $MapPointProps

}

If you need further information, send me a PM

Cheers,

Holger

As promised -> Update WorldMapPoint

## Get Latitude and Longitude for current MapPoint / GET URI for Current MapPoint$PointLatitude = Get-SWISData $Target "SELECT Latitude FROM Orion.WorldMap.Point WHERE Instance = 'Orion.Groups' AND InstanceID =@GroupID" @{GroupID=$GroupID}$PointLongitude = Get-SWISData $Target "SELECT Longitude FROM Orion.WorldMap.Point WHERE Instance = 'Orion.Groups' AND InstanceID =@GroupID" @{GroupID=$GroupID}$MapPointUri = Get-SWISData $Target "SELECT uri FROM Orion.WorldMap.Point WHERE Instance = 'Orion.Groups' AND InstanceID =@GroupID" @{GroupID=$GroupID}

if($PointLatitude -ne $Location.Latitude -or $PointLongitude -ne $Location.Longitude){ $UpdatedPointProps =@{ Instance = 'Orion.Groups' InstanceID = $GroupID Latitude = $Latitude Longitude = $Longitude

} Set-SwisObject $target -Uri $MapPointUri -Properties $UpdatedPointProps Write-Host $Location.Building "moved"}