Need help with reading stuff from JSON

Help
, ,
#1

Hi all,
Need help with reading stuff from JSON. The one I’ve attached. It has 2 instances.
I need to get from it:
name, source_language name , target_language name.

The problem is that it is not readable for Deserialize json array, so that I cant reach these values by using Deserialize JSON.
Pleased for help.

#2

I don’t find any attachments in the post :slight_smile:
And, if it a perfect JSON, then try replacing the double quotes with single quotes and paste it inside the activity. else read it as a string and pass the string to the activity

#3

@HareeshMR, sorry.
Here is a JSON
output.json (1.9 KB)

#4

heyy @Slavich

Try this to get the name ,

image

Please try to get the remaining values and let me know if you stuck anywhere so that I will help you if you need :slight_smile:

1 Like
#5

Deserialize JSON activity is not working for some time. You can create a custom activity for the same in C# and use the same in the workflow.

#6

I’m not sure in which case it is not working @Syed_Kashif_Nasar :slight_smile: . Its working for me in all the cases. Please explain the case so that the staff will have a look and rectify the activity so that we can get the perfect solution for this :slight_smile:

#7

Thank you, @HareeshMR.
I got a single value. But I need the same (name, source_language name, target_language name) for all instances of JSON…
Is there a way to extract them?

#8

You just need to use two more assign activities to get the values :slight_smile: . So please try the same way and let me know if you stuck so that I will help you out

#9

@HareeshMR,
I recieve a generic JSON with different number of instances every time.
Every instance has: name, source_language name, target_language name.
So how can I loop through instances and get these values?

#10

Here is entire thing you need

  1. Name

image

  1. Source Language

image
image873×208 9.63 KB

  1. Target Language

image
image931×276 11.4 KB

You can loop through the JSON Object to get the required values, but if you have the specific element names , what we call (forgot :slight_smile:), like source_language, you can use them to loop through the particular object

1 Like
#11

It works as needed.
Thank you @HareeshMR!

1 Like
#12

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