SchedulesDirect using Powershell

[jcole998]

Hello. I'm trying to access the SD token needed for schedules access using Windows Powershell.

If anyone has any experience or wisdom on how to do this, I would appreciate the help.

This is what I've tried so far but with no success:

$sdUID = 'abcdef'
$sdPW = Get-StringHash -String "123456" -HashName "SHA1"
$sdPW = $sdPW.ToLower()
$jhsdLogin = @{"username"= $sdUID; "password"= $sdPW} | ConvertTo-Json

$sdUAgent = [Microsoft.PowerShell.Commands.PSUserAgent]::InternetExplorer
$sdContentType = "application/json;charset=UTF-8"

$sdToken = Invoke-WebRequest -Uri https://json.schedulesdirect.org/20141201/token -UseBasicParsing -Method Post -Body $jhsdLogin -UserAgent $sdUAgent -ContentType $sdContentType -Debug

This snippet results in "400 Bad Input."

I've also posted on the SchedulesDirect Developer forum.

Thank you.

[mvallevand]

I can't help with the code but a while back XP users had troubles and it was noted that SD load balancers started to reject TLS 1.0 and I am not sure that you should be using the SHA1 hash

If you don't require security for your password change to http:// will be simpler.

Martin

[jcole998]

Thanks, Martin. I've taken up this issue with SD and Mr. K has generously agreed to help find out what I'm doing wrong. All the SD documentation shows that the password should be SHA1 encrypted. Maybe the documents are wrong and I hope that Mr K will see that.

[jcole998]

My helper from SchedulesDirect seems to be rather busy of late which I can understand. So...

sub, would you be kind enough to post the code snippet you use to request a token from SD? Any language.

Thanks.

[mvallevand]

The reference Java source is available at https://github.com/SchedulesDirect/mfdb-json

Martin

[jcole998]

Thanks to all who responded.

I have finally hacked the code to retrieve a token. All data in SchedulesDirect is now available for retrieval and examination. Now I *really* gotta learn Powershell a LOT better! But it's lookin' good!

[sub]

sub, would you be kind enough to post the code snippet you use to request a token from SD? Any language.

Sorry, I've been travelling the last 10 days, so didn't have a chance to respond to this. It sounds like you've got it sorted now.

[jcole998]

Hi, sub, and welcome back. Ten days on the road has to be draining, business or pleasure!

Yeah, I've got SD under control and the data is amazing! A password hash was stopping me, but I've got that beat. Learning Powershell is now the challenge.

Thanks for checking in!