parse out ticket number

[gcue]

Hello

I am trying to get GMS-600 from this $oHTTP.ResponseText but have not been able to figure out the right syntax.  THANK YOU in advance!

$txt = '{"_expands":["participant","status","sla","requestType","serviceDesk"],"issueId":"1301831","issueKey":"GMS-600","requestTypeId":"300","serviceDeskId":"13","createdDate":{"iso8601":"2021-10-12T07:08:17-0700","jira"}}'

;$ticket = StringRegExpReplace($txt, '"issueKey":[\w]', "")
$ticket = StringRegExpReplace($txt, "issueKey[\w]:", "")

Edited October 12, 2021 by gcue

[Melba23]

gcue,

This works for me - and will look for any number of capital letters, a dash, and any number of digits at that position:

$txt = '{"_expands":["participant","status","sla","requestType","serviceDesk"],"issueId":"1301831","issueKey":"GMS-600","requestTypeId":"300","serviceDeskId":"13","createdDate":{"iso8601":"2021-10-12T07:08:17-0700","jira"}}'

$ticket = StringRegExpReplace($txt, '(.*Key":")([A-Z]*-\d*)(",".*)', "$2")

ConsoleWrite($ticket & @CRLF)

It looks for 3 groups: everything up to the end of the "issueKey" section, the section you want, and then all the rest - returning just the second section, which is the one you want.

M23

[gcue]

awesome thank you!!!

[Zedna]

Here is version using _StringBetween():

#Include <String.au3>

$txt = '{"_expands":["participant","status","sla","requestType","serviceDesk"],"issueId":"1301831","issueKey":"GMS-600","requestTypeId":"300","serviceDeskId":"13","createdDate":{"iso8601":"2021-10-12T07:08:17-0700","jira"}}'

$ticket = StringBetween($txt, '"issueKey":"', '"')
ConsoleWrite($ticket & @CRLF)

; wrapper to return string instead of array
Func StringBetween($sString, $sStart, $sEnd)
    $sReturn = _StringBetween($sString, $sStart, $sEnd)
    If @error Then Return ''
    Return $sReturn[0]
EndFunc

 

Edited October 12, 2021 by Zedna

[markyrocks]

this seems to work.  

#include <Array.au3>


$txt = '{"_expands":["participant","status","sla","requestType","serviceDesk"],"issueId":"1301831","issueKey":"GMS-600","requestTypeId":"300","serviceDeskId":"13","createdDate":{"iso8601":"2021-10-12T07:08:17-0700","jira"}}'

$ticket = StringRegExp($txt, "[A-Z]{3}-\d+", 1)

if IsArray($ticket) Then _ArrayDisplay($ticket)

 

Edited October 12, 2021 by markyrocks

[TheDcoder]

Kind of surprised that no one has mentioned using a JSON UDF yet. That's the proper way to do it unless you are really sure that you won't need to do anything else with the response.

[Danp2]

  On 10/12/2021 at 11:11 PM, TheDcoder said:

Kind of surprised that no one has mentioned using a JSON UDF yet.

Expand  

It crossed my mind for a fleeting moment...

[JockoDundee]

  On 10/12/2021 at 11:11 PM, TheDcoder said:

Kind of surprised that no one has mentioned using a JSON UDF yet.

Expand  

What and give up the chance for some tasty RegEx?

[seadoggie01]

Use RegEx and forget it, or spend an hour learning Jason JSON parsing? RegEx wins everytime!

Edited October 13, 2021 by seadoggie01