Add new line to JSON file

[dutta.marina (rpa_06)]

Hi All,

Can any one please help me on this .I want to add new line to my JSON Response txt file .

For example something like this

How to do new line line when writing to the text file

Check this out too… You just need to add VbCrLf in your string Main.xaml (4.4 KB)

[postwick (Paul Ostwick)]

You have to deserialize the JSON into a JSON object, use JSON methods to add/edit the child objects, then .ToString it to get it back into a string

[dutta.marina (rpa_06)]

@Lahiru.Fernando

I downloaded your workflow, where I need to add vbcrl

[postwick (Paul Ostwick)]

Don’t treat it as a text file. It’s JSON. Install the UiPath.WebAPI.Activites package. Use Deserialize JSON to convert the text to a JObject (make sure to set this in the pulldown). Then use an Assign to change the value of yourJSONObjVar(“Quote_Order_from_Discrepancies__c”) to whatever you want just like you’d do with any other variable. If you need it back as a string after that you can use yourJSONObjVar.ToString

[dutta.marina (rpa_06)]

@postwick

Is the below correct?

[postwick (Paul Ostwick)]

No.

1- HTTP Request gets the response in a variable quoteResponseData_source as a string
2- Deserialize JSON (make sure to set it to JObject) converts quoteResponseData_source into a JSON object and puts it into a variable (let’s call it quoteResponseJObj). That object has properties. In your example, there’s just one property Quote_Order_from_Discrepancies__c.
3- Assign quoteResponseJObj = quoteResponseJObj(“Quote_Order_from_Discrepancies__c”).ToString + VbCrLf + “the text you want to add”

The “the text you want to add” could also be a string variable instead of a literal.

Then yourJObj.ToString will spit the whole thing back out as a string. This only needs to be done depending upon your needs. If you want to get the value of just the Quote_Order_from_Discrepancies__c property, you use quoteResponseJObj(“Quote_Order_from_Discrepancies__c”).ToString

[Josh_James (Josh)]

@postwick

JSON methods to add/edit the child objects

Hello - What are these JSON methods to add/edit the child objects? I am trying to add a new key and value inside existing json brackets.

[postwick (Paul Ostwick)]

Using JSON in a UiPath automation

I’ve found myself using JSON more because JObject and the associated methods are actually quite simple, as is the JSON format, but also excellent for storing complex data in a structured string. I built an automation that uses UiPath Forms, the Orchestrator API, and JSON to set the Queue Schema in Orchestrator and I will show how I handled the JSON. For a little background the form looks like this: [image] And here is the resulting JSON: Example JSON.txt (1.7 KB) Now let’s look at how we …