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

Help Studio
, ,
1

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.

2

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)

3

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

4

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:

grafik
grafik1029×775 151 KB

5

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

… indicating there is more:
grafik

7

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

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

Following flow catches the clientIDs:

grafik
grafik989×574 49.6 KB

Logs:
grafik

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

8

thank you, am able to get all the clientids

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.