# Update step back to NetSuite says input data is null

**URL:** <https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389>\
**Category:** Integrator.io\
**Tags:** error-handling, flow-builder, salesforce, netsuite\
**Created:** [August 9, 2023, 4:28pm UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389 "2023-08-09T16:28:38Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![joannewalker](https://avatars.discourse-cdn.com/v4/letter/j/e480ec/32.png) [@joannewalker](https://connective.celigo.com/u/joannewalker)\
**Post date:** [August 9, 2023, 4:28pm UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/1 "2023-08-09T16:28:38Z")

</div>

I have a flow that sends invoices to NetSuite from Salesforce using the payment record in salesforce to trigger the flow and provide the data. The invoices load successfully to NetSuite. Then I have a step that is intended to update a flag on the Salesforce payment record to indicate it has been sent to NetSuite. The data appears on the input section of the screen, but when I preview, it says the key I provided is null.

Any idea why I can see the data on input, but it says it's null when I try to use it? Screen Prints below:

 ![5301043caa20740200000001-988227004dae4472888f9a76f083ba9f.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6324a2ce20e9e7c36564cb604549c26330ec11f4.png)

 ![5301043caa20740200000001-68268fa2d0a1440f8681254ad02e1682.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/9b76b6c1452ceaf800c49d7a23ead536efe2e8a3.png)

---

<div class="post-metadata">

**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\
**Post date:** [August 9, 2023, 5:05pm UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/2 "2023-08-09T17:05:56Z")

</div>

Joanne,

The reason that you are getting null back because IO can not evaluate the expression that is in the "Hoiw can we find existing records" field and hence when it tries to do the lookup it is not returning any value.

Couple of observations that I have made that may help get this to work

1) you will need to remove the [\*] as that field will not iterate over an array as it is meant to be an explicit 1:1 mapping. If that field is in an array you can set the index by using [npe01\_OppPayment\_\_r.0.]Full\_Payment\_ID\_\_c

2) I don't think you need the [] around [npe01\_OppPayment\_\_r.0.] since in handlebars the [] are used to "[Use square brackets to reference field names or values that contain spaces](https://docs.celigo.com/hc/en-us/articles/360038856752-Handlebars-syntax#:~:text=Use%20square%20brackets%20to%20reference,as%20%E2%80%9Cexpressions%E2%80%9D%20in%20Handlebars.). " and it does not look like you have spaces in that name

3) You shouldn't need the string function

Try using this mapping to find existing records

Full\_Payment\_ID\_\_c = npe01\_\_OppPayment\_\_r.0.Full\_Payment\_ID\_\_c

---

<div class="post-metadata">

**Author:** ![joannewalker](https://avatars.discourse-cdn.com/v4/letter/j/e480ec/32.png) [@joannewalker](https://connective.celigo.com/u/joannewalker)\
**Post date:** [August 10, 2023, 3:22pm UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/3 "2023-08-10T15:22:37Z")

</div>

When I set up the 'how can we find existing records', I am not allowed to key in the data name. I can only choose it from the dropdown list of fields, which is where the field name in my screen shot came from. How do I alter what field it should use?

---

<div class="post-metadata">

**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\
**Post date:** [August 11, 2023, 1:27pm UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/4 "2023-08-11T13:27:09Z")

</div>

You can change the input type of that field to value by selecting the settings icon next to that line and selecting "value".

Then you can manually type whatever you need in there

 ![5301043caa20740200000001-1e3ee3c8e1274897a6b28311fa1ff4db.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/dd01ed21ae2da57128085e7edde82ac84902126d.png)

please try that and see if it will resolve your error

---

<div class="post-metadata">

**Author:** ![joannewalker](https://avatars.discourse-cdn.com/v4/letter/j/e480ec/32.png) [@joannewalker](https://connective.celigo.com/u/joannewalker)\
**Post date:** [August 11, 2023, 3:24pm UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/5 "2023-08-11T15:24:13Z")

</div>

I do not have the settings icon on that screen.

 ![5301043caa20740200000001-7a02ad24e3c94982b08a1cddb5c789ac.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/2987fb57f0ad617a666acd14918f5a2f93fcb3a9.png)

---

<div class="post-metadata">

**Author:** ![joannewalker](https://avatars.discourse-cdn.com/v4/letter/j/e480ec/32.png) [@joannewalker](https://connective.celigo.com/u/joannewalker)\
**Post date:** [August 14, 2023, 12:01am UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/6 "2023-08-14T00:01:33Z")

</div>

I did find the settings icon, and I input what you suggested. Here is the error I got:

Message:   
npe01\_\_OppPayment\_\_c where ( Id = npe01\_\_OppPayment\_\_r.0.Full\_Payment\_ID\_\_c  
 ^  
ERROR at Row:1:Column:49  
Bind variables only allowed in Apex code

---

<div class="post-metadata">

**Author:** ![samanthulasrisatyasa](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@samanthulasrisatyasa](https://connective.celigo.com/u/samanthulasrisatyasa)\
**Post date:** [September 5, 2023, 10:58am UTC](https://connective.celigo.com/t/update-step-back-to-netsuite-says-input-data-is-null/389/7 "2023-09-05T10:58:14Z")

</div>

Hi @joannewalker

Try to provide expression as {{{id npe01\_\_OppPayment\_\_r.0.Full\_Payment\_ID\_\_c}}}.

Thanks,

Santosh

cc: @praveenbasani
