Pinned Loading

1. Generate JSON payload from clipboard... Generate JSON payload from clipboard contents.

   1

   # This script was modified to transform a list of deviceID's into an appropriate /

   2

   # JSON format to submit directly to the Workspace ONE API via Postman.

   3

   4

   5

   <# Get device list and outputs to json. #>

2. This article covers the steps to add... This article covers the steps to add and configure Workspace ONE (WS1) API to Postman.

   1

   # Workspace ONE API/Postman Setup

   2

   3

   This article covers the steps to add and configure Workspace ONE (WS1) API to Postman. 

   4

   5

   ## Prerequisites

3. Refresh Excel file using PowerShell Refresh Excel file using PowerShell

   1

   # Disable background refresh on your file

   2

   # Steps:

   3

   # 1. Open File

   4

   # 2. Go to Data Tab

   5

   # 3. Select Refresh Button > More Options > Connection Properties > Untick 'Enable background refresh'

4. Python code snippet to execute SQL q... Python code snippet to execute SQL queries using pyodbc then export results using Pandas. Additional logic to make API requests and save responses.

   1

   import logging

   2

   import pyodbc

   3

   import pandas as pd

   4

   import requests, json

   5

   import queries as query