Important Update: Some Community URL Redirects are Under Maintenance. Learn More. .

cancel
Showing results for 
Search instead for 
Did you mean: 

Archer API Question on data output

RajuMaharjan
Contributor III

We query the Archer report through the API.

                $devices | ForEach-Object{

       $ISI_UAT = $_ | select-object -expand "0-ISI - UAT"

INSERT INTO [dbo]

        ,[ISI_Prod]

 VALUES

        ,'$ISI_Prod' 

This is what it looks like in Archerarcher-api1.PNG 

 

Here is what it looks like in PowerBI just one big string

archer-api2.PNG

The problem at the moment is that the data we’re getting from Archer doesn’t include a delimiter that we can separate the values by.  Would it be feasible to add something like a semicolon at the end of each ISI in the Archer Table?

So we want the response something like VMWare; Server Data; IOT Data Driver Decision Portal.  Is that possible?

1 REPLY 1

DougVaughan
Contributor II

I think you are missing a closing curly bracket in your above example.