Best Of

Hello Robert-Jan van Kuppeveld,

Thank you for the answer, this is what I did as well. I used the Invoke-RestMethod cmdlet to do that. Unfortunately the server I want to run the script on is under SBS 2011 standard, and it seems I am stuck with PowerShell v2.0, which does not support Invoke-RestMethod...

For future reference, here is the code that works with PowerShell v5.1 (on my laptop not my server), that I automated with a .bat so I can launch it from Board. It downloads the data in .json format,  converts it to .csv and stores it in the dataset folder (for example):

function Get-BasicAuthCreds {
 param([string]$Username,[string]$Password)
 $AuthString = "{0}:{1}" -f $Username,$Password
 $AuthBytes = [System.Text.Encoding]::Ascii.GetBytes($AuthString)
 return [Convert]::ToBase64String($AuthBytes)
}
$BasicCreds = Get-BasicAuthCreds -Username "insert username here" -Password "insert password here"

 

Invoke-RestMethod -Uri "insert Url here" -Headers @{Authorization="Basic $BasicCreds"} -Method Get -ContentType application/JSON).SyncRoot | Export-Csv -LiteralPath "insert target file path here" -NoTypeInformation

The first part builds the header I need to send because the API I'm using requires Basic authentication.

In the second part, I needed to add .SyncRoot because it is the name of the item that contains all the data I need (might not be the correct term, I'm not a developper).

For the sake of completeness, this is the contents of the .bat file :

Powershell.exe -ExecutionPolicy unrestricted -File "insert .ps file path here" 

If anyone knows a workaround for PowerShell v2.0, I would be glad to hear about it (online reference seems scarce).

Thank you !

Paul

Hi Paul Wyatt - Avison Young UK - in this case I am copying the objects to the same screen. I have also restarted Board and reopened the screen but to no avail. Sometimes it even copies them outside the visible screen area so I have to go to Screen Objects to find them.

Mike Cirillo - I tried copying the objects into a panel container but when copying they also lost their relative alignment.

I will have to go with Alexander Kappes answer - seems this functionality is rather flaky in 10.3 and unfortunately this is the version we are on for now. Hopefully it improves in the web version but it does seem that layout is not one of Board's strengths compared to other BI tools

Dietmar Jeschkeit thank you so much, it's working (=sum([@a;*;*;Range.Horizontal])/[@a;*;*;CountEX.Horizontal]), it's a simple formula it's perfect !

Paul Wyatt - Avison Young UK  sorry Paul, I should explain in more detail my situation. My principal current difficulty is that I was trained on the older version of Board so I'm trying to cross-check the information. Thank you so much for your patience, you're a good teacher ! 

Have a nice day, 

Hi Paul ! 

I tried to use the most simple way to do that but you're right. 

I've got some difficulties to use Nexel, I never did it before, I'm trying to understand.

You can see below, to me, the formula should work but it doesn't, my last column just copy the first column of values when I would like the average of this four years (if values <> blank).

Thanks by advance, 

I will continue..