-
How to Filter empty date field in SF analytics api?
Using the analytics rest api we need to add a filter to a date field to get only the records where this field is empty. In json: { "column": "Account.Date_Field__c", "operator": "equals", "value": "" },
This filter is also shown if you fetch the report meta data from SF, so the syntax should be correct.
Till the rollout of Summer 14 release it was working as expected, after the release change we get the error message "Filter the date in the correct format. Accepted formats are yyyy-MM-dd'T'HH:mm:ss'Z' and yyyy-MM-dd.]" I checked to use null, but this leads to an error "574902135-2760 (-2136086741)"
Any ideas how to filter on empty date field?
Log In to reply.
Popular Salesforce Blogs
Effective Ways To Use Salesforce For Customer Retention
Why is Customer Retention Important? When techniques are implemented by way of sales groups to hold clients, revenue is going up and fees go down.…
How to Choose the Right Salesforce Consultation Partner for Your Business?
Salesforce consultation partners help businesses establish CRMs and other tech tools, so they perform seamlessly. The primary role here is to collect and maintain databases…
No Code Clearbit and Salesforce Integration
Clearbit is a consumer contact marketing data engine. It assists businesses in expanding by delivering solutions that enable them to better understand their clients, discover…
Popular Salesforce Videos
Salesforce Admin Mock Interview Questions and Answers
In this Salesforce Mock Interview Series, I'm dropping the seventh podcast/video of the Salesforce Admin Mock Interview Questions and Answers. This will help you to…
Google Home Assistant Integration with Salesforce
Check out the below link for pdf view. https://www.linkedin.com/pulse/google-home-assistant-integration-salesforce-rajkiran-dewara/
Methods in Salesforce - All You Need to Know
Learn All About Methods in Salesforce. Watch this video and do let us know if you have any doubts or concerns. What is a Method…