Late binding error in jsonstring

Help Studio
, ,
1

Hi ,
I am trying to extract “CaptureID” and “Enterprise code” from below jsonString . But i get late binding error .Please help

"ANFPaypalTran": [
{
  "Createts": "2024-02-08T10:24:58-05:00",
  "PaypalAuthID": "6SD31476KG641924B",
  "Createprogid": "OMSC_ORDER-VIEW",
  "PaypalTranKey": "202402081024595748785632",
  "CoProcessFlag": "Y",
  "InvoiceNo": "71438917",
  "OrderNo": "13101793501",
  "CaptureID": "5ML07915LG414280H",
  "ChargeAmount": "80.63",
  "Modifyuserid": "ANFPaypalCapToCOServer",
  "Modifyprogid": "ANF_PP_CAP_TO_CO",
  "Modifyts": "2024-02-08T10:28:51-05:00",
  "ChargeTransactionKey": "202402081024435748789586",
  "RefundedAmount": "0.00",
  "Createsuserid": "admin",
  "PaypalOrderID": "O-5HN49148EV7115349",
  "EnterpriseCode": "001",
  "Lockid": "1"
}

]
}

2

Hi @tharani.natarajan

Use Deserialize JSON Activity and store in variable jsonObject

And Try below ones in Assign Activity:

captureID = jsonObject("ANFPaypalTran")(0)("CaptureID").ToString

enterpriseCode = jsonObject("ANFPaypalTran")(0)("EnterpriseCode").ToString

Hope it will helps you :slight_smile:
Cheers!!

1 Like
3

Hi @tharani.natarajan

jsonObject("ANFPaypalTran")(0)("CaptureID").ToString()

jsonObject("ANFPaypalTran")(0)("EnterpriseCode").ToString()

image
image

Hope it helps!!

1 Like
4

Thanks .I had given datatype as object instead of jobject .

1 Like
5

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