Hello Everyone!,
Is there a way to fetch the conversation history that is located in the "Case" module through API?
Like
Hello,
Yes, it is possible to fetch the conversation history related to a Case through the API. However, the conversation history is not stored directly within the Case module. Instead, this data is maintained in a separate Activity table.
Each entry in the Activity table - such as emails, calls, notes, or messages - is linked to a Case via a foreign key relationship. This means that each activity record includes a reference to the specific Case it belongs to.
To retrieve the conversation history for a particular Case, you will need to use the API to query the Activity table and filter the results based on the Case’s ID. This will return all the related communication entries tied to that Case.
Creatio supports the OData protocol, which enables structured querying through parameters. OData is a standardized, REST-based protocol that allows for the querying and manipulation of data using simple HTTP messages and URIs, enabling seamless integration between data sources and clients.
To filter records, you can use the $filter parameter along with the eq (equals) operator. For example :
https://mycreatio.com/0/odata/Collection1?$filter=Field2 eq 'Field2Value'
This allows you to request a filtered collection of Activity records where the Case reference matches a specific value.
You can find more detailed guidance in the official Creatio OData API documentation.