1

For a dashboard I want to get some basic information about all cases. e.g get all open cases. I did find some api functionality to gather data by id about a single case.

https://developer.salesforce.com/docs/api-explorer/sobject/Case

Is is possible to receive data about all cases?

Improve this question
4
  • Retrieve Summary for Case option should give you all cases. Have you tried it?
    – Rohit Mourya
    Commented Jan 7, 2020 at 10:20
  • Could you explain this? I'm not very familiar with salesforce but I am with api's
    – Jeroen de Beer
    Commented Jan 7, 2020 at 10:27
  • @Joroen This API gives you the Case records: /services/data/v39.0/sobjects/Case However what I observe is that not all fields are retrieved. I think you need to retrieve those records using Data Loader.
    – Rohit Mourya
    Commented Jan 7, 2020 at 10:36
  • thanks! I'll have a look
    – Jeroen de Beer
    Commented Jan 7, 2020 at 10:40

1 Answer 1

Reset to default
3

You probably want to execute a SOQL query via this API. Think of SOQL as a very basic version of SQL (some features not available, such as wildcards *), and the 'Case' object as your table. The query might look something like

SELECT Id, Subject, Status FROM Case WHERE IsClosed = false LIMIT 1000

And the request might look something like:

curl https://yourInstance.salesforce.com/services/data/v20.0/query/?q=SELECT+Id+Subject+Status+FROM+Case -H "Authorization: Bearer token"
Improve this answer
1
  • Thanks, as soon as I have the credentials I'll let you know if it worked
    – Jeroen de Beer
    Commented Jan 7, 2020 at 11:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .