I am working with SuiteQL and RESTful web services. I am trying to query a field custrecord_upaya_cutomer_#, however it doesn't seem to like that. I'm getting an invalid Field Identifier, however when I do a 'SELECT * FROM' I'm seeing that field in the returned result set. Any guidance on how to query that would be helpful. My assumption is that it has to do with the #, I have tried escaping the entire string with {} and just the character with \ with no luck. TIA!

You could try building the query in a workbook and exporting to suiteql to see how that looks. There's even a chrome extension for that already 😂 https://chrome.google.com/webstore/detail/netsuite-workbook-to-suit/egmkcpbmbcfenkfmphbfomegdckknnhj?hl=en

Thanks, I'll give that a try.