# \#jsonarray **URL:** https://forum.uipath.com/tag/jsonarray/3905.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [How to joing arrays of values in single string](https://forum.uipath.com/t/how-to-joing-arrays-of-values-in-single-string/5746197)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [May 14, 2026, 10:21am UTC](https://forum.uipath.com/t/how-to-joing-arrays-of-values-in-single-string/5746197 "2026-05-14T10:21:27Z")
i have jason where i need to fetch scope value and there can be 1 or multiple scope so json is - full json - \[ { “id”: 477, “type”: “project”, “scopeType”: “project”, “scope”: 22000, “teamId”: 296, “teamName… --- ## [How to saperate values from jason if json contains same key multiple times](https://forum.uipath.com/t/how-to-saperate-values-from-jason-if-json-contains-same-key-multiple-times/5746145)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 10\ **Last updated:** [May 14, 2026, 9:00am UTC](https://forum.uipath.com/t/how-to-saperate-values-from-jason-if-json-contains-same-key-multiple-times/5746145 "2026-05-14T09:00:39Z")
Hello, i have below json and i need to get value of scope and need to write in excel i able to achieve this with below code but some times scope is comming 2 or more than 2 times in jso like below , in that c… --- ## [How to saperate specific value from json](https://forum.uipath.com/t/how-to-saperate-specific-value-from-json/5745980)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 3\ **Last updated:** [May 14, 2026, 8:57am UTC](https://forum.uipath.com/t/how-to-saperate-specific-value-from-json/5745980 "2026-05-14T08:57:29Z")
Hello, i am getting below as json response from http request i need to saperate scope value only so expected output is - 53002 it give below error if i use deserialize json how can i achive this? --- ## [How to saperate values wit comma or semicolon](https://forum.uipath.com/t/how-to-saperate-values-wit-comma-or-semicolon/5736648)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 3\ **Last updated:** [April 8, 2026, 6:47am UTC](https://forum.uipath.com/t/how-to-saperate-values-wit-comma-or-semicolon/5736648 "2026-04-08T06:47:34Z")
Hello, we are fetching details from jira tikcet using api. In the ticket there is on euser field which contains usernames and when user creates the ticket they enter in below manner- ex 1 - abc,pqr,xyz or ex2- abc … --- ## [Deserialize JSON/Deserialize JSON Array](https://forum.uipath.com/t/deserialize-json-deserialize-json-array/5696460)
**Author:** [@conai\_smith](https://forum.uipath.com/u/conai_smith)\ **Replies:** 4\ **Last updated:** [December 10, 2025, 5:25pm UTC](https://forum.uipath.com/t/deserialize-json-deserialize-json-array/5696460 "2025-12-10T17:25:52Z")
Error: Deserialize JSON: Deserialized JSON type ‘Newtonsoft.Json.Linq.JArray’ is not compatible with expected type ‘Newtonsoft.Json.Linq.JObject’. Path ‘’, line 1, position 713. It keeps showing this error despite usi… --- ## [Add Key to JObject Conditionally](https://forum.uipath.com/t/add-key-to-jobject-conditionally/820852)
**Author:** [@benjamin.9052](https://forum.uipath.com/u/benjamin.9052)\ **Replies:** 2\ **Last updated:** [January 15, 2025, 11:55am UTC](https://forum.uipath.com/t/add-key-to-jobject-conditionally/820852 "2025-01-15T11:55:17Z")
Hi I am trying to add a Key to the Jobject based on a condition. I am not able to find the syntax . Can someone Help me with the Syntax to use If condition inside the JObject. for eg : If value1 is not Null ( add Key … --- ## [Trouble selecting token from JSON Array](https://forum.uipath.com/t/trouble-selecting-token-from-json-array/814759)
**Author:** [@jamiejam](https://forum.uipath.com/u/jamiejam)\ **Replies:** 4\ **Last updated:** [January 12, 2025, 3:04pm UTC](https://forum.uipath.com/t/trouble-selecting-token-from-json-array/814759 "2025-01-12T15:04:58Z")
Good afternoon UiPath Forum, I have successfully created a JSON array and can read the tokens. The issue is that each token now has a value under it with its own array. I am at the level I need to be in the JSON data … --- ## [How to replce value in text file of json](https://forum.uipath.com/t/how-to-replce-value-in-text-file-of-json/772190)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [October 9, 2024, 7:20am UTC](https://forum.uipath.com/t/how-to-replce-value-in-text-file-of-json/772190 "2024-10-09T07:20:50Z")
Hello, i have below json and saved as in text json file { “billableSeconds”: 10800, “timeSpent”: “3h”, “location”: { “name”: “Default Location”, “id”: 1 }, “attributes”: { “WorkLocation”: { “workAttributeId”: … --- ## [Extarct value from json](https://forum.uipath.com/t/extarct-value-from-json/772074)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [October 8, 2024, 7:40am UTC](https://forum.uipath.com/t/extarct-value-from-json/772074 "2024-10-08T07:40:46Z")
Hello, I have below json { “billableSeconds”: 10800, “timeSpent”: “3h”, “location”: { “name”: “Default Location”, “id”: 1 }, “attributes”: { “WorkLocation”: { “workAttributeId”: 1, “value”: “”, “type”: “STAT… --- ## [Problem converting JSON Array to DataTable to then append in an Excel file](https://forum.uipath.com/t/problem-converting-json-array-to-datatable-to-then-append-in-an-excel-file/768056)
**Author:** [@alex87](https://forum.uipath.com/u/alex87)\ **Replies:** 3\ **Last updated:** [September 27, 2024, 7:33am UTC](https://forum.uipath.com/t/problem-converting-json-array-to-datatable-to-then-append-in-an-excel-file/768056 "2024-09-27T07:33:09Z")
Hello, I call an API every 4 hours that returns me an update of some data by project. I need to put the new values bellow the existing ones in an Excel file (append). Here is an example of the API output: example-jso… --- ## [Search through different json files, and find the same value](https://forum.uipath.com/t/search-through-different-json-files-and-find-the-same-value/766171)
**Author:** [@christian.bendtsen](https://forum.uipath.com/u/christian.bendtsen)\ **Replies:** 9\ **Last updated:** [September 11, 2024, 10:37am UTC](https://forum.uipath.com/t/search-through-different-json-files-and-find-the-same-value/766171 "2024-09-11T10:37:57Z")
I have a lot of different json files, and i want to extract some specific values from these json files. Example, i have these 3 different files, json1, json2, json3. for json1 i want do extract line: 105 “text”: “Omr… --- ## [Getting JSON Array in a Single Line](https://forum.uipath.com/t/getting-json-array-in-a-single-line/762301)
**Author:** [@Raunak\_Bhanarkar](https://forum.uipath.com/u/Raunak_Bhanarkar)\ **Replies:** 1\ **Last updated:** [August 26, 2024, 10:26am UTC](https://forum.uipath.com/t/getting-json-array-in-a-single-line/762301 "2024-08-26T10:26:19Z")
Hey, Im trying to get a response here of JSON array in a single line but it is giving in multi line array. Can someone help me with it? The is the response im getting { “id\_success”: true, “user\_id”: “”, “email”: “”… --- ## [Json string have dobbelt quotes ("" ""), cant make it to single quote (" ")](https://forum.uipath.com/t/json-string-have-dobbelt-quotes-cant-make-it-to-single-quote/751006)
**Author:** [@christian.bendtsen](https://forum.uipath.com/u/christian.bendtsen)\ **Replies:** 10\ **Last updated:** [July 2, 2024, 1:53pm UTC](https://forum.uipath.com/t/json-string-have-dobbelt-quotes-cant-make-it-to-single-quote/751006 "2024-07-02T13:53:21Z")
Hallo. I have an json string, when i write it to the console or workbook it looks correct. But when i try to use it in UiPath, it gives me dobbelt quotes like this: @"\[ { ““FullName””: ““Tonmmy Dehl””, ““PhoneNum… --- ## [Unable to extract values from the JSON body](https://forum.uipath.com/t/unable-to-extract-values-from-the-json-body/729377)
**Author:** [@jishnu.pnair](https://forum.uipath.com/u/jishnu.pnair)\ **Replies:** 10\ **Last updated:** [May 30, 2024, 6:14am UTC](https://forum.uipath.com/t/unable-to-extract-values-from-the-json-body/729377 "2024-05-30T06:14:53Z")
Hi Team, Please see the below JSON body from which i need to extract specific values. { “id”: “7702d0e6-f443-4fdb-aa4f-8b187092a08a”, “name”: “XXX”, “status”: “Limited Scope”, “meetingRequestForm”: { “id”: “9c85a8… --- ## [\ How to extract worklogs value "uipath" from below mentioned json?](https://forum.uipath.com/t/json-value-extracting-how-to-extract-worklogs-value-uipath-from-below-mentioned-json/717328)
**Author:** [@anjasing](https://forum.uipath.com/u/anjasing)\ **Replies:** 9\ **Last updated:** [February 5, 2024, 10:38am UTC](https://forum.uipath.com/t/json-value-extracting-how-to-extract-worklogs-value-uipath-from-below-mentioned-json/717328 "2024-02-05T10:38:50Z")
JSON Doc.txt (741 Bytes) { “transactionId”: “”, “invokingUser”: “”, “timestamp”: “”, “data”: \[ { “created\_by”: “”, “created\_date”: “”, “status”: “ABC”, “attachments”: \[ { “created\_by”: “”, “created\_date”: “” … --- ## [Get specific values form json file](https://forum.uipath.com/t/get-specific-values-form-json-file/716601)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 9\ **Last updated:** [February 1, 2024, 10:54am UTC](https://forum.uipath.com/t/get-specific-values-form-json-file/716601 "2024-02-01T10:54:16Z")
Hello, i need to split below json and need to get values of defects check below json { “testExecutionKey”: “P000110-15004”, “tests”: \[ { “status”: “PASS-PARTIALLY”, “testKey”: “P000110-6436”, “start”: “2023-11-2… --- ## [Use for each boucle with Json](https://forum.uipath.com/t/use-for-each-boucle-with-json/716317)
**Author:** [@frederic-f.bonnet](https://forum.uipath.com/u/frederic-f.bonnet)\ **Replies:** 6\ **Last updated:** [January 31, 2024, 11:14am UTC](https://forum.uipath.com/t/use-for-each-boucle-with-json/716317 "2024-01-31T11:14:20Z")
Hi , hello , How do I configure a for loop ( see image ) so that the loop changes at each id. In this case the data for each id ( nni , first name , last name … etc ) used in the process of the robot ( in the form of … --- ## [Extarct json](https://forum.uipath.com/t/extarct-json/715592)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [January 29, 2024, 10:29am UTC](https://forum.uipath.com/t/extarct-json/715592 "2024-01-29T10:29:28Z")
hello, i need only data value which is under attachment which is under tests for each test key below json contains only 1 test key data. check below json { “testExecutionKey”: “P003106-3677”, “tests”: \[ { “status… --- ## [How to split json](https://forum.uipath.com/t/how-to-split-json/714675)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 6\ **Last updated:** [January 25, 2024, 10:55am UTC](https://forum.uipath.com/t/how-to-split-json/714675 "2024-01-25T10:55:42Z")
hello, i need to fetch only data values from below json { “testExecutionKey”: “P003106-4272”, “tests”: \[ { “status”: “PASS”, “testKey”: “P003106-4264”, “start”: “2022-11-02T08:54:16+01:00”, “finish”: “2022-11-03… --- ## [How to get specific values form json](https://forum.uipath.com/t/how-to-get-specific-values-form-json/714876)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [January 25, 2024, 10:51am UTC](https://forum.uipath.com/t/how-to-get-specific-values-form-json/714876 "2024-01-25T10:51:53Z")
hello, please check below json { “testExecutionKey”: “P003106-4272”, “tests”: \[ { “status”: “PASS”, “testKey”: “P003106-4264”, “start”: “2022-11-02T08:54:16+01:00”, “finish”: “2022-11-03T10:08:09+01:00”, “execu… --- ## [How to get value from json](https://forum.uipath.com/t/how-to-get-value-from-json/714646)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 3\ **Last updated:** [January 24, 2024, 10:03am UTC](https://forum.uipath.com/t/how-to-get-value-from-json/714646 "2024-01-24T10:03:23Z")
Hello, i have below json { “testExecutionKey”: “P000110-7887”, “tests”: \[ { “status”: “TODO”, “testKey”: “P000110-6436”, “defects”: , “evidences”: \[“kunal”\], “steps”: , “assignee”: “”, “testEnvironments”: , … --- ## [Extract objects from JSON with nested JSON arrays](https://forum.uipath.com/t/extract-objects-from-json-with-nested-json-arrays/698350)
**Author:** [@jacchr](https://forum.uipath.com/u/jacchr)\ **Replies:** 8\ **Last updated:** [November 16, 2023, 1:41pm UTC](https://forum.uipath.com/t/extract-objects-from-json-with-nested-json-arrays/698350 "2023-11-16T13:41:07Z")
Hi Experts I have a JSON response looking like this: { "auditIdg": "cjmifeoijje-jfddsof743-sfjofe837632-dj733i4", "familyTree": { "cId": 1234567, "fullBusinessName": "AJAX INC", "affilia… --- ## [Creating and storing Json array with a for each loop to be able to post](https://forum.uipath.com/t/creating-and-storing-json-array-with-a-for-each-loop-to-be-able-to-post/513859)
**Author:** [@duaine.b](https://forum.uipath.com/u/duaine.b)\ **Replies:** 3\ **Last updated:** [November 11, 2023, 10:27am UTC](https://forum.uipath.com/t/creating-and-storing-json-array-with-a-for-each-loop-to-be-able-to-post/513859 "2023-11-11T10:27:57Z")
Scenario - I have arrays that I would like to store in a json array to be able to post. Array values can be seen in image attached. I have a set of companyids in an array, the number of companyids may not always be two.… --- ## [Appending two jobjects into one](https://forum.uipath.com/t/appending-two-jobjects-into-one/687573)
**Author:** [@duaine.b](https://forum.uipath.com/u/duaine.b)\ **Replies:** 8\ **Last updated:** [November 10, 2023, 4:36pm UTC](https://forum.uipath.com/t/appending-two-jobjects-into-one/687573 "2023-11-10T16:36:01Z")
Hi I wanted to merge two Jobjects into 1 initial Jobject: { “GUID”: “e080fdc6-20e2-4661-bb45-df27fb58d619”, “ClientInfo”: { “DelphiScore”: “999”, “DocumentKey”: “76149c73-45de-477c-bc27-0a8f2f6ad46b”, “DocumentUrl… --- ## [Extract data from JSON Object](https://forum.uipath.com/t/extract-data-from-json-object/664435)
**Author:** [@darie.leolea](https://forum.uipath.com/u/darie.leolea)\ **Replies:** 2\ **Last updated:** [October 27, 2023, 12:30pm UTC](https://forum.uipath.com/t/extract-data-from-json-object/664435 "2023-10-27T12:30:46Z")
Hi, I need to extract the last value from the Json Object and I don’t find a solution. Thanks in advance! --- ## [After deserializing json string moving to next line for \\n for some cases but not for all](https://forum.uipath.com/t/after-deserializing-json-string-moving-to-next-line-for-n-for-some-cases-but-not-for-all/624042)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 15\ **Last updated:** [October 11, 2023, 10:40am UTC](https://forum.uipath.com/t/after-deserializing-json-string-moving-to-next-line-for-n-for-some-cases-but-not-for-all/624042 "2023-10-11T10:40:21Z")
Hello, after etting result from http request call i am deserializing that json. check below comment part in json i am getting using http request. u can see here comment contains multiple \\n 1\] after desrializing … --- ## [JSON array adding new values issue](https://forum.uipath.com/t/json-array-adding-new-values-issue/596981)
**Author:** [@darie.leolea](https://forum.uipath.com/u/darie.leolea)\ **Replies:** 1\ **Last updated:** [September 20, 2023, 7:49am UTC](https://forum.uipath.com/t/json-array-adding-new-values-issue/596981 "2023-09-20T07:49:35Z")
Hello, I am trying to build a JSON, but the main issue is with the JSON array structure. So the desired structure look like this: “key1”: “sample string”, “key2”: “sample string”, “key3”: \[ { “key4”: “sample strin… --- ## [String going to new line due to \\n in json](https://forum.uipath.com/t/string-going-to-new-line-due-to-n-in-json/574933)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 6\ **Last updated:** [August 24, 2023, 11:51am UTC](https://forum.uipath.com/t/string-going-to-new-line-due-to-n-in-json/574933 "2023-08-24T11:51:18Z")
Hello, I am getting json by calling some data using http request. That json contains assignee,iterations,comments and some values. i need to read this json and rearange in specific format and to do that i am not using… --- ## [Unexpected character error in json](https://forum.uipath.com/t/unexpected-character-error-in-json/573867)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [August 18, 2023, 2:08pm UTC](https://forum.uipath.com/t/unexpected-character-error-in-json/573867 "2023-08-18T14:08:39Z")
hello i am getting below error when i am checking line 124 in son it contains some data like below i am desrialising jsong using below way not using direct desrialize json activity as it is changing my date forma… --- ## [How to update json with another value](https://forum.uipath.com/t/how-to-update-json-with-another-value/573211)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 1\ **Last updated:** [August 16, 2023, 6:14pm UTC](https://forum.uipath.com/t/how-to-update-json-with-another-value/573211 "2023-08-16T18:14:51Z")
Hello, My reuirement is if assignee field is empty means if assignee is like below “assignee”: , then need to fill value of executed by in assignee , here executed by value is abc so my end json is with assignee … [Next page](https://forum.uipath.com/tag/jsonarray/3905.md?match_all_tags=true&page=1&tags%5B%5D=jsonarray)