# Using wixData.bulkinsert with an Array

**URL:** <https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459>\
**Category:** Ask the community\
**Tags:** question, code\
**Created:** [December 7, 2019, 11:53am UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459 "2019-12-07T11:53:38Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![tom66859](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@tom66859](https://forum.wixstudio.com/u/tom66859)\
**Post date:** [December 7, 2019, 11:53am UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/1 "2019-12-07T11:53:38Z")

</div>

I am trying to use bulk update function in backend [https://www.wix.com/corvid/reference/wix-data.html#bulkUpdate](https://www.wix.com/corvid/reference/wix-data.html#bulkUpdate) . The documentation looks like is has to split the array of elements e.g. toUpdate[1] and toUpdate[2] rather than toUpdate.

```javascript
wixData.bulkUpdate("myCollection", [toUpdate1, toUpdate2], options)

```

Is their a way to use bulkUpdate with just the array?

---

<div class="post-metadata">

**Author:** ![lee1](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/lee1/32/2931_2.png) [@lee1](https://forum.wixstudio.com/u/lee1)\
**Post date:** [December 7, 2019, 1:02pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/2 "2019-12-07T13:02:08Z")

</div>

[toUpdate1, toUpdate2] **is** just an array. So yes, you can pass your existing array if you already have one, rather than constructing one as they do in the documentation.

---

<div class="post-metadata">

**Author:** ![doughammack](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/doughammack/32/108659_2.png) [@doughammack](https://forum.wixstudio.com/u/doughammack)\
**Post date:** [December 7, 2019, 7:18pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/3 "2019-12-07T19:18:30Z")

</div>

I have been trying to make this work for days, I have an array but I am not getting anything. Any tips would be greatly appreciated!

```javascript
export function ythHmsGenerate() {
	wixData.query("IndividualJudgesPlacings")
		.eq("ythHms", true)
		.eq("owner", user.id)
		.limit(100)
		.find()
		.then((results) => {
			console.log(results)
			let items = results.items;
			let titles = items.map(item => item.title);
			console.log("here are titles" + titles)
			wixData.query("NationalChampionshipRankings")
				.not(
					wixData.query("NationalChampionshipRankings")
					.hasSome("title", titles)
				)
				.eq("youthHms", true)
				.limit(100)
				.find()
				.then((results) => {
					console.log(results)
					let items2 = results.items
					let needsToBeInserted = items2.map(item => [item.title, item.youthHms, item.youthEq, item.youthSms])
	shows in console as array---->	console.log(needsToBeInserted)
					wixData.bulkInsert("IndividualJudgesPlacings", [needsToBeInserted])
					//console.log("done maybe");
					//console.log ("Bulk Insert Results" + results)
					// $w("#repeater1").expand();

					//	.catch((err) => {
					// let errorMsg = err;
				});
		})
}

```

---

<div class="post-metadata">

**Author:** ![lee1](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/lee1/32/2931_2.png) [@lee1](https://forum.wixstudio.com/u/lee1)\
**Post date:** [December 7, 2019, 7:58pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/4 "2019-12-07T19:58:18Z")

</div>

@doughammack  
Remove the brackets around needsToBeInserted. That makes your existing array the only element in a new array.

---

<div class="post-metadata">

**Author:** ![doughammack](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/doughammack/32/108659_2.png) [@doughammack](https://forum.wixstudio.com/u/doughammack)\
**Post date:** [December 7, 2019, 8:08pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/5 "2019-12-07T20:08:00Z")

</div>

@lee1 Thanks for the response. When I take away the brackets I get no entries inserted, when I leave the brackets I get 1 entry and its blank

---

<div class="post-metadata">

**Author:** ![lee1](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/lee1/32/2931_2.png) [@lee1](https://forum.wixstudio.com/u/lee1)\
**Post date:** [December 7, 2019, 8:28pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/6 "2019-12-07T20:28:08Z")

</div>

I think needsToBeInserted should be an array of objects, not an array of arrays. So also change

```javascript
[item.title, item.youthHms, item.youthEq, item.youthSms]

```

to

```javascript
({item.title, item.youthHms, item.youthEq, item.youthSms})

```

You need the parenthesis else it would be interpreted as a code block.

---

<div class="post-metadata">

**Author:** ![doughammack](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/doughammack/32/108659_2.png) [@doughammack](https://forum.wixstudio.com/u/doughammack)\
**Post date:** [December 7, 2019, 8:55pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/7 "2019-12-07T20:55:32Z")

</div>

Thanks Lee. When I tried that I get an array of “undefined” but I get an array has the correct number of objects

---

<div class="post-metadata">

**Author:** ![lee1](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/lee1/32/2931_2.png) [@lee1](https://forum.wixstudio.com/u/lee1)\
**Post date:** [December 7, 2019, 9:03pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/8 "2019-12-07T21:03:25Z")

</div>

Haha we’ll get there eventually.

```javascript
let needsToBeInserted = items2.map(item => ({
	title: item.title,
	youthHms: item.youthHms,
	youthEq: item.youthEq,
	youthSms: item.youthSms
}));

```

---

<div class="post-metadata">

**Author:** ![doughammack](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/doughammack/32/108659_2.png) [@doughammack](https://forum.wixstudio.com/u/doughammack)\
**Post date:** [December 7, 2019, 9:06pm UTC](https://forum.wixstudio.com/t/using-wixdata-bulkinsert-with-an-array/33459/9 "2019-12-07T21:06:58Z")

</div>

@lee1 You sir are the man! That got it, it is know working correctly!!!
