According to the help, you can supply the getinput stage with a query-object or an object that points to a workbook. Is it possible to somehow supply a SuiteQL?

I havent tried but maybe have the getInput return

query.runSuiteQL()

?

Haven't tried either, hoped that someone else might have. runSuiteQL() doesn't really return a query-object, so it feels like it shouldn't work. Might have to give it a try tomorrow. 😀

it returns a

resultSet

though, which the

getInput

should take in theory

It's not documented as a valid return value for getInputValue, however there is an example of doing so in SuiteQL example section

{
  type: 'suiteql',
  query: 'SELECT field FROM table',
  params: []
};

Nice, I'll try that one! Thanks @michoel!