REF_ROWS output to variable

[AI-FL]

This may not be REF_ROWS at all but here goes. 

I have an inline Ref table (Parts) displayed on the Details page of my Job table records.  I have an AppScript that I am posting payload to Quickbooks and I would like to pass this Ref table to a variable and iterate thru later in the script.

I am seeing the inline table fine but the Test output on REF_ROWS expression is not showing any list data.  Maybe they are not the same?   

[dbaum · Accepted solution]

The REF_ROWS function returns a list of values from the referencing table's key column. Are you seeing something else?

[dbaum · Accepted solution]

The REF_ROWS function returns a list of values from the referencing table's key column. Are you seeing something else?

[AI-FL · Accepted solution]

I found the issue.  I needed to return a list, but not of the key column.  I am using SELECT now and getting the expected list of values.

Thanks.