Netsuite - Google Sheet Pre-Built Flow Issues

Integrator.io
,
1

Prebuilt flow for the Netsuite - Google Sheet Integration isn`t working properly when Saved Search is type of Transaction.

I think issue is with the hooks - It only pulls the first row of the saved search then it errors out due key field is missing even though source data has it "Internal ID"

Hooks maybe expecting each rows to have unique Internal ID but with the transactions that`s the case if journal entry has 10 lines you will have 10 lines of same internal id in the saved search.

2

Are you using the "group" feature on the export? Also, are you expecting 2 fields to be the key i.e. internal id and line id? You could also just use "line unique key"?

3

I have tried both -

Internal ID - Unique to each transaction

Then I have created a Unique ID for each line by combining Internal ID + Line ID - Thinking maybe flow really wants to see unique id for each line

It works on test mode since it`s only pulling the first line but when I turn on the integration and run, it errors out.

4

can you share what the error message is? or some images of the flow and flow steps?

5

The error I am getting is : The record is missing a value for the field: Internal ID. This field is required, because the value is used to determine if a row should be updated vs appended in the spreadsheet.

This Error doesn`t make sense because each line of the export has Internal ID

Code : missing_required_field
Source : Pre map hook
Message: The record is missing a value for the field: Internal ID. This field is required, because the value is used to determine if a row should be updated vs appended in the spreadsheet.

I am unable to share screenshots, my company policy somehow blocks uploading files here. I am happy to send it via email.

My Export:

Record Type = Transaction
Saved Search = "Transaction Saved searc"
Group Rows.

My Import :

SpreadSheet ID: Populated
Shee Name: Populated
Does your sheet have column headers: Checked.
Headers : automatically calculated (Matches to the Google Sheet)

Column to find existing rows :Internal ID
Source record field to find existing rows : Internal ID

When I preview I get error too : [
{
"code": "missing_required_field",
"message": "The record is missing a value for the field: Internal ID. This field is required, because the value is used to determine if a row should be updated vs appended in the spreadsheet.",
"source": "pre_map_hook",
"resolved": false,
"occurredAt": 1748872000567
}

When I adjust my saved search to look for 1 transaction only I don`t get any errors, so basically if I pull 1 journal entry from Netsuite flow works but when I pull multiple it errors out.

6

There is no reason to use "group rows" in this case. Can you disable that and then use line unique key as the "Column to find existing rows" and "Source record field to find existing rows".

7

Is it possible to do screen sharing?

When I undo the Grouping and re-try - Run Console shows the Integration ran successfully however no data being populated in the Google Sheets.

Step Status Success Ignored Errors Auto-resolved Pages Duration Completed
Pull Saved Search Completed 1034 0 Success 0 52 00:00:13 06/02/2025 10:28:10 am
Update existing rows and append new rows Completed 1034 0 Success 0 52 00:01:28 06/02/2025 10:29:30 am
8

When I look at the Google Sheet cell audits - I am seeing cells are being replaced with " " . Basically when integrator runs it replaces the data with the blank values and it shows successful in UI - Somehow data gets erased within the process I think..

9

You may have to redo your mappings after removing the grouping. Maybe start a fresh flow without grouping and then a new import and freshly map everything in?

10

Tyler - you were right re-doing the whole thing made the trick. Thanks for your help.

I got this error but my file was limited to 1000 rows after expanding the rows to 3k - Error went away.
{"error":{"code":400,"message":"Invalid data[19]: Range (Sheet2!1001) exceeds grid limits. Max rows: 1000, max columns: 27","status":"INVALID_ARGUMENT"}}

11

Can you share what you're sheet looks like? How many rows of data do you have? How many columns? Are you making a table that just includes the whole sheet and only a few rows/columns are populated?

Maybe you can join office hours next week and show us: https://zoom.us/meeting/register/338c30f6ce7573eacde7dc3c8da9331e#/registration