How to extract/get the Client id from get API?

[manipreethi410]

i need to extract the ClientId from the below text, please find the .text file below

try.txt (10.9 KB)

getting this values from the get API.

Can we use “Deserialize JSON” Activity, if so please explain i tried every way. also tried with using split method.

[ppr (Peter Preuss)]

It looks like JSON Data, maybe you can send us the complete JSON

However give try:

• “Deserialize JSON” Activity - myJObject

• Assign Activity:
  strClientID = myJObject(“clientId”).Value(Of String)

[manipreethi410]

what even there in text file that is the complete value which i got it for API

[ppr (Peter Preuss)]

In case of multiple ClientIDs will be present, then we do need the complete JSON.

A regex on the JSON Text could look like following:

[ppr (Peter Preuss)]

@manipreethi410

what even there in text file that is the complete value which i got it for API

it looks like an incomplete copy e.g. from locals
No starter is present

… indicating there is more:

[ppr (Peter Preuss)]

JSON starts with [ - JArray
Or
JSON starts with { - JObject

Lets assume following is reflecting your JSON (still last provided JSON was incomplete)

Following flow catches the clientIDs:

Logs:

The LINQ compact statement for all ClientID as a string Array looks like:

[manipreethi410]

thank you, am able to get all the clientids