Nested Json Error

💬 Workflows
1

I have some code in a workflow but it seems not to like to drill down to the array of an array in a JSON input record.

const data = query_ClickUp_View_Page.data.tasks;

var jsonArray = [];
var jsonObject;

var i = 0;
var id = "";
var custom_id = "";
var po = "";
var customer_id_array = [];
var customer_id = "";

for (i == 0 ; i < data.length ; i ++) {
  id = data[i].id;
  custom_id = data[i].custom_id;
  po = data[i].custom_fields.filter(row => row.id == "111")[0].value;
  customer_id_array = data[i].custom_fields.filter(row => row.id == "111)[0].value;
  /*customer _id = customer_id_array. <nothing works>
  customer_id = customer_id_array; // this works
  
  jsonObject = {'order_id': id, 'order_number': custom_id, 'customer_po': po, 'customer_id': customer_id};
  jsonArray.push(jsonObject);
}

return jsonArray

It returns the following:

{
	"data": [
		{
			"order_id": "XXXX",
			"order_number": "YYYY",
			"customer_po": "ZZZZ",
			"customer_id": [
				{
					"id": "AAAA",
					"name": "The Name",
					"deleted": false,
					"access": true
				}
			]
		},
		{
			"order_id": "1234",
			"order_number": "5678",
			"customer_po": "123455",
			"customer_id": [
				{
					"id": "BBB",
					"name": "The Other Name",
					"deleted": false,
					"access": true
				}
			]
		},
	]
}

Will like to get the id of the customer instead but no matter what I try it seems not to like it.

Any suggestions?

2

Hi @Dataland,

customer_id is an array, so you'll want to access the [0] index to access the values. You could use find instead of filter which would return the first instance as an object, instead of an array of found value (if you know there is only ever 1 to find).

You can also simplify your JS a bit into something like this, which will use map to iterate over your tasks, building the result into an array.

return query_ClickUp_View_Page.data.tasks.map( task => { // Map will return an array of processed data
  const {id, custom_id} = task // Pull those 2 values right out of the task data
  const po = task.custom_fields.find(row => row.id === '111').value // I'm not sure what this is or how it differs from the customer_id_array
  const customer_id = task.custom_fields.find(row => row.id === '111').value.id // access the value.id property of the found data 
  return {id, custom_id, po, customer_id
}
3

Thanks @MikeCB for your response and for changing upgrading my code. i am not a developer, and my brain is always thinking of divide and conquer instead of doing everything at once. Great learning opportunity here...

Anyhow, I have done everything to access this array and is not possible...

I just tried your suggested code and I get the same than I getting when I try to get any content of that array.

{"data":null,"error":"TypeError: Cannot read properties of undefined (reading 'id') (line x)"}

Even with my code I get the same error... it only works if i don't try to get anything from the customer array. The only thing that works is if I only get the value:
const customer_id = task.custom_fields.find(row => row.id === '111').value
Anything after the value fails.

I have even tried getting that json on another code block, etc.

I decided to create a new workflow, and have the test data as my input as shown on my original post. The issue is data related, nothing related to the code. When I get a couple of records from the array it works perfectly, but when I get the whole dataset (100 records) it doesn't like it.

Will review the data and report back!

4

Sigh!!! The wrong assumption was made... from all the dataset (more than 1k records ONLY one doesn't have the customer id array, so it cannot evaluate the content of a non existing array.

Here is the code that ended doing exactly what I needed with always having the 4 elements with the desired names of each json row:

return query_ClickUp_View_Page.data.tasks.map( 
  task => {
    const order_id = task.id;
    const order_number = task.custom_id;
    const tmp_po = task.custom_fields.find(row => row.id === '111').value;
    const customer_po = (tmp_po != null ? tmp_po : "");
    const tmp_array = task.custom_fields.find(row => row.id === '222').value;
    const customer_id = (tmp_array != null ? tmp_array[0].id : "");
    return {order_id, order_number, customer_po, customer_id};
  }
)

Thanks Mike for showing me how to use the map function instead of creating a loop.

1 Like