INVALID_FIELD No such column 'XXX' on entity 'YYY' - Salesforce

INVALID_FIELD No such column 'XXX' on entity 'YYY' - Salesforce

Problem

You are getting an error message like this when testing your Salesforce cart or running Order Download:

Make sure you have given read access to the column & entity listed in the error message below.

INVALID_FIELD: SELECT Id, AccountId, CreatedDate, PoNumber, OrderNumber, TotalAmount ^ ERROR at Row:1:Column:36 No such column 'PoNumber' 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.

Solution

This is due to a permissions issue in Salesforce.

  1. Look at the entity and column name displayed in the error message.
    1. In the sample above the entity is "Order" and the column is "PoNumber"
  2. Navigate to the specific field mentioned in the Salesforce Setup menu.
  3. Click the Set Field-Level Security button.
  4. Make sure it has read access or above.


    • Related Articles

    • Salesforce API Limit

      Problem REQUEST_LIMIT_EXCEEDED: TotalRequests Limit exceeded. If you are receiving the above error in your Salesforce connection, there are a few possible reasons and a few possible solutions. Reason You have other applications accessing Salesforce ...
    • Enable Shipping Confirmation - SalesForce

      Custom order fields are needed in SalesForce for CartRover to upload tracking info.  Step-by-step guide Go to your SalesForce Dashboard, then click on Setup button on the top right corner.  Type order in the Quick Find/Search box.  Go to Customize → ...
    • Setting Up SalesForce

      Integration Specs: Supported functions: Order Download Shipment Confirmation Inventory Sync Required Parameters Account Username Account Password This integration supports Salesforce Service Cloud & Sales Cloud Premium Setup SalesForce Setups in ...
    • Invalid api path - Magento

      Problem CartRover displays the following error message when connecting to Magento: Invalid api path Solution This error is most commonly caused by improperly adding custom endpoints to the Magento API, which breaks/blocks the standard API endpoints. ...
    • Invalid response from WooCommerce

      Problem You are receiving the following error message in CartRover: Invalid response from WooCommerce. CartRover only uses the native functionality built into WooCommerce without modifying it in any way. CartRover does not need nor provide a ...