Format-AMUri is defaulting to US Date format in UK timezone

[smistry-mangroup]

Expected Behavior

PS C:\Users\smistry> Get-AMInstance -Status Running

StartDateTime EndDateTime ConstructType ConstructName AgentName Status

---

24/01/2022 19:07:02 24/01/2022 19:07:11 Process HeartbeatProcessAgent dlondbbfms71 Running

Actual Behavior

Get-AMInstance

failure : Invalid format of parameter 'range_start'
At C:\Program Files\WindowsPowerShell\Modules\AutomatePS\5.1.0\Functions\Public\Invoke-AMRestMethod.ps1:103 char:13
+             throw "$($tempResult.Result) : $($tempResult.Info)"
+             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (failure : Inval...r 'range_start':String) [], RuntimeException
    + FullyQualifiedErrorId : failure : Invalid format of parameter 'range_start'

Steps to Reproduce the Problem

1. Login to pc built on UK timezone
2. Install AutomatePS
3. Connect to Automate Instance
4. Run Get-AMInstance

Specifications

• AutomatePS Version: 5.1.0
• PowerShell Version: PSVersion 5.1.19041.1320
• Automate Version: 11.5.0.94

Note, I found a workaround was to update Format-AMUri to use GetDateTimeFormats()[77] to format the date in yyyy-MM-dd HH:mm:ss format e.g. 2022-01-25 15:13:25

example

    if ($PSBoundParameters.ContainsKey("RangeStart")) {
        $Parameters += "range_start=$($RangeStart.ToUniversalTime().GetDateTimeFormats()[77])"
    }
    if ($PSBoundParameters.ContainsKey("RangeEnd")) {
        $Parameters += "range_end=$($RangeEnd.ToUniversalTime().GetDateTimeFormats()[77])"

[davidseibel]

Thanks for sharing - good suggestion, but in my testing it seems to only work in PowerShell 5, not in PowerShell 7. Here's a solution that should work for both versions. Can you test with this and let me know if it works? Thanks

if ($PSBoundParameters.ContainsKey("RangeStart")) {
    $Parameters += "range_start=$($RangeStart.ToUniversalTime().ToString((Get-Culture).DateTimeFormat.SortableDateTimePattern))"
}
if ($PSBoundParameters.ContainsKey("RangeEnd")) {
    $Parameters += "range_end=$($RangeEnd.ToUniversalTime().ToString((Get-Culture).DateTimeFormat.SortableDateTimePattern))"
}

[smistry-mangroup]

Hi David, Thanks for picking this up! I’ve applied your code and it is working on my machine. Format-AMUri.ps1 ***@***.*** Date format is send to API correctly. range_start=2022-02-07T09:00:41&range_end=2022-02-08T09:00:41 PS C:\Users\smistry> Get-AMInstance -Status Running -Verbose VERBOSE: 08/02/2022 09:00:41 - Invoke-AMRestMethod started VERBOSE: 08/02/2022 09:00:41 - Calling API (server: U-AP-ATM-M01) VERBOSE: GET http://u-ap-atm-m01:9708/BPAManagement/instances/running/list?range_start=2022-02-07T09:00:41&range_end=2022-02-08T09:00:41&sort_field=StartDateTime with 0-byte payload VERBOSE: received 135474-byte response of content type application/json; charset=utf-8 VERBOSE: 08/02/2022 09:00:44 - Converting from JSON (server: U-AP-ATM-M01) VERBOSE: 08/02/2022 09:00:44 - Casting objects to correct type (server: U-AP-ATM-M01) VERBOSE: 08/02/2022 09:00:44 - Invoke-AMRestMethod finished Powershell version on my machine PSVersion 5.1.19041.1320 Is there is anything else you want me to check? Thanks Sunil Mistry Platform Technology ***@***.******@***.***> Tel +44 20 7144 3948 [logo] Man Group plc | Riverbank House, 2 Swan Lane | London EC4R 3AD | United Kingdom Registered in Jersey no. 127570 Visit us at: www.man.com<http://www.man.com> P Man Group is a signatory to the UN-supported Principles for Responsible Investment Please consider the environment before printing this email From: David Seibel ***@***.***> Sent: 07 February 2022 17:04 To: automateps/AutomatePS ***@***.***> Cc: Mistry, Sunil (London) ***@***.***>; Author ***@***.***> Subject: Re: [automateps/AutomatePS] Format-AMUri is defaulting to US Date format in UK timezone (Issue #27) External Email: Caution advised.

…

________________________________ Thanks for sharing - good suggestion, but in my testing it seems to only work in PowerShell 5, not in PowerShell 7. Here's a solution that should work for both versions. Can you test with this and let me know if it works? Thanks if ($PSBoundParameters.ContainsKey("RangeStart")) { $Parameters += "range_start=$($RangeStart.ToUniversalTime().ToString((Get-Culture).DateTimeFormat.SortableDateTimePattern))" } if ($PSBoundParameters.ContainsKey("RangeEnd")) { $Parameters += "range_end=$($RangeEnd.ToUniversalTime().ToString((Get-Culture).DateTimeFormat.SortableDateTimePattern))" } — Reply to this email directly, view it on GitHub<#27 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ARUVRESFNX6NF3NQ2RP7NSLUZ73Q5ANCNFSM5MYRGTHA>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>> This email has been sent by a member of the Man group (“Man”). Man's parent company, Man Group plc, is registered in Jersey (company number 127570) with its registered office at 22 Grenville Street, St Helier, Jersey, JE4 8PX. The contents of this email are for the named addressee(s) only. It contains information which may be confidential and privileged. If you are not the intended recipient, please notify the sender immediately, destroy this email and any attachments and do not otherwise disclose or use them. Email transmission is not a secure method of communication and Man cannot accept responsibility for the completeness or accuracy of this email or any attachments. Whilst Man makes every effort to keep its network free from viruses, it does not accept responsibility for any computer virus which might be transferred by way of this email or any attachments. This email does not constitute a request, offer, recommendation or solicitation of any kind to buy, subscribe, sell or redeem any investment instruments or to perform other such transactions of any kind. Man reserves the right to monitor, record and retain all electronic and telephone communications through its network in accordance with applicable laws and regulations. During the course of our business relationship with you, we may process your personal data, including through the monitoring of electronic communications. We will only process your personal data to the extent permitted by laws and regulations; for the purposes of ensuring compliance with our legal and regulatory obligations and internal policies; and for managing client relationships. For further information please see our Privacy Notice: https://www.man.com/privacy-policy