nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Insight Cloud API Powershell

Gary Smith_hufw55

Hi I am trying to import assets into Insight using there API.

I have worked out how to view objects but I'm a little lost on how to add new objects.

I can't work out how to attach the JSON to invoke-restMethod.

I have my sample input JSON like this.

$InputJSON = @"
{
"objectTypeId": $6,
"attributes": [{
"objectTypeAttributeId": 22,
"objectAttributeValues": [{
"Default": "$room_name"
}],
"attributes": [{
"objectTypeAttributeId": 46,
"objectAttributeValues": [{
"Default": "$calendar_name"
}]
}]
}

And I'm trying to add it to this call.

$InsightURL = "https://insight-api.riada.io/rest/insight/1.0/object/create"
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12;
$Headers = {    
Authorization  = "Bearer e6292...597f"    
'Content-Type' = 'application/json'
}
$r = Invoke-RestMethod -Uri $InsightURL -Headers $headers -Method POST

Is it supposed to go in the headers? Is there a particular way to attach it?

Any help would be awesome or if anyone has a script example that they could show me that would be even better!

I'm using cloud version if that matters.

Accepted answers

All comments

Tobias Ravenstein

To append your JSON to the Post request you can use the Body parameter of Invoke-RestMethod like this:

$r = Invoke-RestMethod -Uri $InsightURL -Headers $headers -Method POST -Body $InputJSON

Gary Smith_hufw55

I did try that but had an error so I reduced it down to its simplest form and found out that I had

"objectTypeId": $6

instead of

"objectTypeId": 6

But I still get a error

Invoke-RestMethod : {"errorMessages":[],"errors":{"rlabs-insight-attribute-22":"At least one value must be set"}}

So this is what my object looks like.

Annotation 2020-06-17 112216.png (Removed the link to parent object for now.

As you can see I am just going to import some zoom rooms and link the assets between the rooms, and the hardware in said room.

This is my simplified script, trying to just create a object with a 'test' label and nothing else.

$InputJSON = @"
    {
        "objectTypeId": 6,
        "attributes": [{
"objectTypeAttributeId": 22,
            "objectAttributeValues": [{
                "Default": "Test"
            }]
        }]
    }

$InsightURL = "https://insight-api.riada.io/rest/insight/1.0/object/create"

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12;

$Headers = {
Authorization  = "Bearer e62...597f"
    'Content-Type' = 'application/json'
}

Invoke-RestMethod -Uri $InsightURL -Headers $Headers -Body $InputJSON -Method POST

Tobias Ravenstein

I got it working on a completly fresh cloud instance, so my id's are 1 fore the objecttype and 2 for the atrribute.

Here is my JSON:

$InputJSON = @"
{
    "objectTypeId": 1,
    "attributes": [{
        "objectTypeAttributeId": 2,
        "objectAttributeValues": [{
            "value": "Demo"
        }]
    }]
}

You need to write

"value": "Demo"

"value" instead of "Default" <- this in the documentation is reffering to the type of the attribute which can be a "default" like text, interger, float and so on or some special attribute like a jira user or project.

And here is the call which was successful:

$InsightURL = "https://insight-api.riada.io/rest/insight/1.0/object/create"
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12;
$Headers = @{ 
Authorization = "Bearer 6ed...0a85f" 
'Content-Type' = 'application/json'
}

$r = Invoke-RestMethod -Uri $InsightURL -Headers $headers -Method POST -Body $InputJSON

Hope this will help you.

Regards
Tobias

Gary Smith_hufw55

Thank you so much!
Been going crazy trying to work it out.

I looked back at my revisions because I was sure that I used what they had and I had capitalized 'Value'.

This will get me through the eval stage to decide if we want to run with it, but i am not looking forward to writing these scripts where i need to work off the ID instead of the name.

Might have to build a module if we go with this application.

Again, thanks heaps for your help.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-desk

rest

api

insight

json

powershell