Save/print json output from azure cognitive services

Help
1

I am trying to use azure cognitive services to find the gender and age
Microsoft vision scope to set service URL and key
detect faces and save output
JSON / JArray Conversion Activities to save output to csv

not able to save data to csv or print output as table on the screen, please help !

main-vision
main-vision1337×541 41.9 KB

syncroot

FaceImage[1]
{
FaceImage
{
Age=56,
Gender=“Male”,
Position=
[{
X=174,Y=121,Width=37,Height=37
}]
}
}

Raw view

FaceImage
{
Age=56,
Gender=“Male”,
Position=
[{
X=174,Y=121,Width=37,Height=37
}]
}

Thanks,
Yousef

2

Hi @yousef-liveroute

you can use deserialie json activity and use the json to csv

Thanks
ashwin S

3

Can please guide me on how to use deserialie json activity on saved variable type faceimage

Thanks,
Yousef

4
5

It says input should single quote, but the output coming from Microsoft is a json array without single quote

Still i am getting please guide me

Thanks,
Yousef

6

Please try to retrieve value from array and store it in a separate variable then try to Deserialize.

7

@yousef-liveroute

  1. Just install UiPath.web.activities , you will get deserialize json activity
  2. whatever the output or JSON you are getting, pass the same to the activity as well
  3. Then use the json as required
8

Thanks for the follow-up, still no luck !

uipath-json-error
uipath-json-error1363×565 42 KB

uipath-json-error2
uipath-json-error21099×416 22.2 KB

Thanks,
Yousef

9

Can you post the JSON you are getting as output of the HTTP request? @yousef-liveroute

10

thanks for follow-up

I am not sure if there is another way to get the http request, please find below the raw view output

Raw-view
Raw-view1001×565 10.5 KB

Thanks,
Yousef

11

If you check the properties of http request, you will have the output fields as result and status @yousef-liveroute, Check if you are getting json as the result.

The one you are passing to deserialize JSON activity is not the JSON I guess, please try to display it in the message box before passing to the deserialize activity so that you can understand

12

unfortunately could not manage to display output !

messagebox

Thanks,
Yousef

13

You are passing that to deserialize activity. so it is throwing the error. Can you post the http activity as well for my understanding @yousef-liveroute?

14

I am new to UiPath studio I can see below error

Deserialize JSON: Unexpected character encountered while parsing value: U. Path ‘’, line 0, position 0.

Thanks,
Yousef

15

@yousef-liveroute, you may please refer this video to handle JSON data

#HappyRobotics

16

Yes @yousef-liveroute , I understand. You are not passing JSON to the activity so it is throwing error. Attach the workflow if possible, so that it will be easy to check

17

Thanks nice if i am using offline json file, but my case already the output is a variable in memory

18

much appreciated please find attached main.xaml Main.xaml (6.2 KB)

19

Some of the dependencies you have installed are missing the workflow attached @yousef-liveroute

Can you zip the workflow along with project.json and upload here?

20

sure uploaded the project folderVisionProject.zip (15.2 KB)