SELECT Id,name,celigo_sfnsio__NetSuite_Id__c ^ ERROR at Row1Column:11 No such column 'name' on entity 'Order'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names., Status Code: 422

AI generated answer (using internal Slack threads):

From the conversations, it seems like you are encountering different errors while working with NetSuite and Celigo integration. For the first error

[Code=UNEXPECTED_ERROR] An unexpected error occurred. Error ID: jvvzmbc216qz831x6qhp3

, it's a generic error message from NetSuite which doesn't provide much information about the root cause. It's recommended to retry the operation and if the error persists, you may need to review the data you are sending in your request. The second error

Failed to save record because You have entered an Invalid Field Value 1403 for the following field: shipmethod

indicates that the value provided for the 'shipmethod' field is not valid. It could be due to the shipping method with internal id 1403 being set to inactive or not existing. However, you mentioned that it does exist and is active. It's suggested to check the mapping in Celigo and also check if there are any default ship methods set on the customer profiles within NetSuite. The third error

Error Received during Netsuite Query Code: INVALID_KEY_OR_REF Type: ERROR Message: Invalid CUSTENTITYZUORASENDTOZUORA reference key

suggests that there might be an issue with the permissions for the custom entity field or the reference key is not valid. It's recommended to check if all the scripts are deployed to your custom role that are currently deployed to admin. Remember, these are suggestions based on the information provided in the conversations and the actual solution might vary based on the specific details of your implementation and setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******