Complex JSON Serialization

Help
1

I am trying to serialize a complex json. There are arrays within arrays, arrays of objects, etc.

From what I have found through these forums, there are ways to serialize arrays, but doesn’t go into more complex configurations. Ideally I could build a vb.net object and serialize it, however I don’t see that is possible with the out of the box invoke code activity. Is there any other way I could accomplish this?

Thank you!

Edit: I am trying to go from individual data points → JSON string. Not the other way around. From comments I’m getting maybe that was unclear.

2

You could build a custom activity that takes in your json and outputs a serialized string

3

Hi @Greer,

Whatever may be the complexity you can achieve this by the existing JSON activities in UiPath.

Have you tried with those?

4

Just to clarify - I am trying to go from individual string data points into a JSON formatted string. I am using JsonConvert.SerializeObject(), but that only seems to be handle a single array.

5

Hi @Greer

Are you attempting to serialize a multi-dimensional array?

6

No, whatever we can do with JSON in code, we can do that with the existing activities, If it has multidimensional array also.

7

This is an example of the json I need to create:
{

“personalizations”: [

{ “to”: [

{ “email”: “test@domain.com”, “name”: “Recipient Name” }

],

“dynamic_template_data”: {

“URL”: “www.google.com”,

“refId”: “12345”,

“Amount”: “123.12”

}

}

],

“template_id”: “1231112”,

“from”:

{ “email”: “me@mycompany.com”, “name”: “Program Support” },

“reply_to”:

{ “email”: " me@mycompany.com ", “name”: " Program Support " },

“tracking_settings”:{ “open_tracking”: { “enable”: true } }

}

8

Fixed formatting:

{

    “personalizations”: [

        { 
            “to”: 
            [

                {
                    “email”: "test@domain.com", “name”: “Recipient Name” 
                }

            ],

            “dynamic_template_data”: 
            {

                “URL”: “www.google.com”,

                “refId”: “12345”,

                “Amount”: “123.12”

            }

        }

    ],

    “template_id”: “1231112”,

    “from”:

    { 
        “email”: "me@mycompany.com", “name”: “Program Support” 
    },

    “reply_to”:

    { 
        “email”: " me@mycompany.com ", “name”: " Program Support " 
    },

    “tracking_settings”:
    { 
        “open_tracking”: 
        { 
            “enable”: true 
        } 
    }

}

Do you have examples of the individual data pieces you input to this?

9

I will likely be using a datatable for the “to”, and a dictionary for the “dynamic_template_data”, “from”, “reply_to”, all else will be primitive data types

10

@Greer

Are the dictionaries as such:

Dictionary<string, string>
11

Yep! exactly

12

The best thing I can recommend is to build a custom activity that takes each item as input and outputs a serialized json string.

These are good resources for building one:

1 Like
13

@Greer

Not sure if you still need a solution, but I attempted to make an activity for this.
SerializeDataCustomActivity.1.0.0.nupkg (5.7 KB)

If you could try it out and let me know if you run into errors, that’d be greatly appreciated.

1 Like
14

I am having a hard time being able to open up and view that attachment. Can you please post the project.json or xaml?

15

Can you please explain which activities I can use?

16

Hi Greer,

The attachment I posted is a nuget package. To use it in your project, add it to the local dependency folder for UiPath. Then in manage packages, add it to the project.

1 Like
17

That is incredibly helpful, thank you! @nlee1131 Looks like I’ll need to make a package then.

18

Here’s an example of a custom activity
Serialize.cs (2.1 KB)

This is within a Class Library (.NET Framework) in Visual Studio

2 Likes
19

Here is the workflow to extract data from the JSON you provided @Greer ,

jsonComplex.zip (3.9 KB)

For every value from the json you want, you can get it with the key values

1 Like
20

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