Save/print json output from azure cognitive services

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 !

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

Hi @yousef-liveroute

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

Thanks
ashwin S

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

Thanks,
Yousef

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

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

@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

Thanks for the follow-up, still no luck !

uipath-json-error

uipath-json-error2

Thanks,
Yousef

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

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

Thanks,
Yousef

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

unfortunately could not manage to display output !

messagebox

Thanks,
Yousef

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?

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

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

#HappyRobotics

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

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

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

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?

sure uploaded the project folderVisionProject.zip (15.2 KB)