Forum Discussion

Kelemvor's avatar
Kelemvor
Icon for Expert rankExpert
2 years ago

Using Postman to create multiple Websites via API & CSV?

Hi, I’m testing out creating websites (or resources) via the API.  I have a standard Post working in Postman just fine.  However, when I then try to do the same thing via a CSV file in the Runner se...
api
postman
rest api
  • Kelemvor's avatar
    Kelemvor
    9 months ago

    Well, just bumping this because it came up again yesterday.  I was able to create a device group with no issues, but simply by change it from device/groups to website/groups made it all break.  It ended up being the version.  When I tried to add it to the URL it didn’t help.  What seemed to work was to specify it in the header like this:

    Once I did that, everything seemed to start working.  Just in case it comes up for me again, I’m documenting it here.  Or if it helps anyone else, there you go.  :)

Joe_Williams's avatar
Joe_Williams
Icon for Professor rankProfessor
2 years ago

This is dirty but should get the idea out there. This was a tab delimeted file not a csv but reading a csv is pretty simple.

$accessId = ''
$accessKey = ''

$ParentFolder = '5937'

$httpVerb = 'POST'
$resourcePath = '/device/groups'
$url = 'https://PORTAL.logicmonitor.com/santaba/rest' + $resourcePath

$Locations = Import-Csv C:\Users\user\Downloads\folders.txt -Delimiter "`t" -Header "SiteName","Street","City","State","Zip"

foreach ($Location in $Locations) {
    Write-Host $Location.SiteName
    $data = '{"name":"' + $Location.SiteName + '","parentId":' + $ParentFolder + ',"customProperties":[{"name":"location","value":"' + $Location.Street + ", " + $Location.City + ", " + $Location.State + " " + $Location.Zip + '"}]}'
    $epoch = [Math]::Round((New-TimeSpan -start (Get-Date -Date "1/1/1970") -end (Get-Date).ToUniversalTime()).TotalMilliseconds)
    <# Concatenate Request Details #>
    $requestVars = $httpVerb + $epoch + $data + $resourcePath

    <# Construct Signature #>
    $hmac = New-Object System.Security.Cryptography.HMACSHA256
    $hmac.Key = [Text.Encoding]::UTF8.GetBytes($accessKey)
    $signatureBytes = $hmac.ComputeHash([Text.Encoding]::UTF8.GetBytes($requestVars))
    $signatureHex = [System.BitConverter]::ToString($signatureBytes) -replace '-'
    $signature = [System.Convert]::ToBase64String([System.Text.Encoding]::UTF8.GetBytes($signatureHex.ToLower()))

    <# Construct Headers #>
    $auth = 'LMv1 ' + $accessId + ':' + $signature + ':' + $epoch
    $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
    $headers.Add("Authorization",$auth)
    $headers.Add("Content-Type",'application/json')

    $response = Invoke-RestMethod -Uri $url -Method $httpVerb -Header $headers -Body $data
}