Invalid Or Null For Restricted Picklist

When you encounter the INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST error in your integration between Revenue.io and Salesforce, it indicates that the system is attempting to populate a Salesforce picklist field with a value that is not defined in that picklist's available options.

This is a common issue when external systems like Revenue.io send data values that don't match the exact values configured in your Salesforce picklist fields.

Common Causes

• Value case mismatch (e.g., "high priority" vs. "High Priority")
• Special characters or extra spaces in the transmitted values
• New values being sent from Revenue.io that haven't been added to the corresponding Salesforce picklist
• Deactivated picklist values in Salesforce that are still being sent by Revenue.io

Troubleshooting Steps

1. Identify the affected picklist field:

   Review your Salesforce logs to determine which specific picklist field is causing the error. The logs should indicate which field value is being rejected.

   • Example: "Error updating record: bad value for restricted picklist field: Stuck on Gatekeeper (INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST)"
2. Compare the incoming values with allowed values:

   Check the value that Revenue.io is attempting to send against the values configured in your Salesforce picklist:

   1. Navigate to Setup in Salesforce
   2. Go to Object Manager
   3. Select the relevant object
   4. Click on Fields & Relationships
   5. Find and click on the picklist field in question
   6. Review the Values section to see all currently configured options
3. Check for exact matches:

   Verify that the values from Revenue.io exactly match the Salesforce picklist values, including case sensitivity, spacing, and any special characters.

Resolution Strategies

As a Salesforce Administrator, you have two primary approaches to resolve this issue:

Option 1: Update the Salesforce Picklist (Recommended)

1. Add missing values to the Salesforce picklist:
   1. Navigate to Setup Object Manager [Object Name] Fields & Relationships
   2. Select the picklist field that's causing the error
   3. Click "Edit" next to Values
   4. Add the values being sent by Revenue.io to the picklist
   5. Save your changes

Option 2: Modify the Revenue.io Configuration

If you prefer not to alter your Salesforce picklists, you can work with your Revenue.io administrator to ensure the values being sent match your existing picklist values:

1. Provide your Revenue.io administrator with the exact list of acceptable values from your Salesforce picklist fields
2. Have them update their mapping or configuration to ensure only valid values are sent
3. Test the integration after changes are made to confirm the error is resolved

Need Additional Help?

If you've followed the steps above and are still experiencing issues:

• Review the Revenue Logs for more detailed information about which field value is causing the error
• Contact Revenue.io Support with specific examples of the values being transmitted