# HOW TO: What's the best way to load a static lookup with a lot of items?

**URL:** <https://connective.celigo.com/t/how-to-whats-the-best-way-to-load-a-static-lookup-with-a-lot-of-items/1453>\
**Category:** Integrator.io\
**Tags:** csv, ui-ux, json, lookup\
**Created:** [July 13, 2020, 5:33pm UTC](https://connective.celigo.com/t/how-to-whats-the-best-way-to-load-a-static-lookup-with-a-lot-of-items/1453 "2020-07-13T17:33:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![docssupport](https://avatars.discourse-cdn.com/v4/letter/d/df788c/32.png) [@docssupport](https://connective.celigo.com/u/docssupport)\
**Post date:** [July 13, 2020, 5:33pm UTC](https://connective.celigo.com/t/how-to-whats-the-best-way-to-load-a-static-lookup-with-a-lot-of-items/1453/1 "2020-07-13T17:33:54Z")

</div>

You'll need to format your lookup entries in JSON format. If you have it in CSV format, you can convert it to JSON using a text editor. Once you have it in JSON format, you can copy and paste it in the API request data. You should load at least one entry via the UI, so that when you look at the data via API, you can tell exactly where the remaining data needs to go.   
  
Example:

```
"lookups": [{ "name": "5f40018e0b424fea88c2ea234903fef8", "map": { "DebitLine_": "10100", "Order_ItemPrice": "10200", "Order_ItemWithheldTax", ... }, "allowFailures": false }], 
```

---

<div class="post-metadata">

**Author:** ![jackharris](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/jackharris/32/6618_2.png) [@jackharris](https://connective.celigo.com/u/jackharris)\
**Post date:** [June 21, 2024, 2:22pm UTC](https://connective.celigo.com/t/how-to-whats-the-best-way-to-load-a-static-lookup-with-a-lot-of-items/1453/2 "2024-06-21T14:22:41Z")

</div>

Where do you put that code?

---

<div class="post-metadata">

**Author:** ![kathyanaqueeman](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kathyanaqueeman/32/9122_2.png) [@kathyanaqueeman](https://connective.celigo.com/u/kathyanaqueeman)\
**Post date:** [June 21, 2024, 3:02pm UTC](https://connective.celigo.com/t/how-to-whats-the-best-way-to-load-a-static-lookup-with-a-lot-of-items/1453/3 "2024-06-21T15:02:17Z")

</div>

Hi @jackharris,

This is fairly old content. I'm validating this solution with someone on our team before we recommend this. I'll reach out to you here with an update. Thanks!

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [June 21, 2024, 3:54pm UTC](https://connective.celigo.com/t/how-to-whats-the-best-way-to-load-a-static-lookup-with-a-lot-of-items/1453/4 "2024-06-21T15:54:30Z")

</div>

@jackharris this is on the import itself. If you have a field that uses a static mapping, then you can use our api to put in a large amount of mappings. You can either use postman or my preference of [Zangabox](https://chromewebstore.google.com/detail/zangabox/bamdljjdfabfogmdkbjjigjpeebmfdek?pli=1)chrome extension. Here is a screenshot example of an import I have with a static mapping for a field. You can see there is a lookups array at the root level and then in the mapping section it references the lookupName.

 ![5301043caa20740200000001-35a914d1a30d4cfb9a3baa3c5aeac0bc.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c5d49dc59af9dcbee1495ad5b418741cbffa6849.png)