API JSON flow

Help Activities
,
1

Hi everyone, i have a project here which I am suppose to put an email body which I already have a value onto the json body of the API, Please help the flow of it.

2

@Anelisa_Bolosha

Can you please explain a little…the requirements are little unclear

Cheers

3

Please try deserializing the json to a datatable and you can use it in the email body as per your requirement from the table.

If its something else you are looking at please ellaborate.

@Anelisa_Bolosha

4

Hi @Anelisa_Bolosha

After you get the response from API call. You can use Deserialize Json Activity like this

sample json

{
  "ticket_id": "12345",
  "user_info": {
    "user_id": "user001",
    "name": "John Doe",
    "email": "johndoe@example.com"
  },
  "issue_details": {
    "subject": "Login Issue",
    "description": "Unable to login to the system since yesterday.",
    "priority": "High",
    "status": "Open"
  },
  "creation_date": "2023-11-29",
  "last_updated": "2023-11-29",
  "assigned_to": {
    "employee_id": "emp100",
    "name": "Jane Smith",
    "department": "IT Support"
  },
  "comments": [
    {
      "comment_id": "comm001",
      "author": "Jane Smith",
      "date": "2023-11-29",
      "text": "Initial assessment completed. Requesting further details."
    }
  ]
}

Let say you want to extract the issue_details > description Key , we can use

DeserializedResponse.SelectToken("issue_details").SelectToken("description").ToString

image
image685×632 26.1 KB

Cheers

5

Please use deserialize json activity with email body as input and pass on the output to the API call.

6

Hi guys thank you for all your responses,
So I need to insert an email body value under “inputs”…send a request then when the request result response come, they come like this:

17012631514886128250542494188397
170126315148861282505424941883971920×864 89.8 KB

On the response on “labels”: [“claims”,…]
I want the first one “claims”

7

Hi @Anelisa_Bolosha

Could you share the image again ? The upload didn’t work correctly

8

Oh okay apologies,i uploaded please check

9

Thank you @Anelisa_Bolosha

Could you share the sample json like in the image?

10

{
“inputs”: “Hi, kindly receive an attached request to cancel my policy.”
}

17012670918306586990451162504337
170126709183065869904511625043371920×864 93.9 KB

11

@Anelisa_Bolosha

oh I got it.

How about this

image
image880×573 18.2 KB

image
image1173×443 19.4 KB

image
image1129×647 36.6 KB

payload = "{
'inputs': '"+Mail.Body.ToString.Trim+"'
}"