Trouble generating output schema with Execute SuiteQL Query

Help Activities
, ,
1

Hi all! I am running into an error when trying to generate the output schema using oracle netsuite Execute SuiteQL Query activity.

I am getting the following error message: the Could not generate custom fields schema. Provider message: Custom fields configuration cannot be retrieved. Consider recreating the activity. Error code: DAP-DT-2253.. Please validate Query field input and try again

Has this happened to anyone else/does anyone else have any insight on what the issue might be? My user profile in NetSuite has access to custom objects and I double checked that the query is correct. Any advice would be appreciated!

1 Like
2

Hi, Were you able to resolve this issue. We are facing similar issues.

1 Like
3

Having new lines in some of my old query text caused it to not be able to Generate the output schema when I migrated an automation to a new org.
After using the Expression Editor Test to generate the sql output without whitespace new lines I was able to copy that into the select query * box and generate the output schema.

4

Hey team, I am also facing the same error. How to fix this? I also wonder why it cant generate output schema dynamically on its own upon running. There is definitely space for improvement here.