Trying to create new Reminding with link to Call or Contact collection objectby oData4 request. Is it possible?
With Action collection everything fine. But with Call (or Contact) collection Id request only red point appears near bell symbol, but list of remindings is empty.

Like 0

Like

2 comments

Hello!

If you mean create remindings with link to specific record. You actually can manage something like this with the business process b...MoreLess

Show all comments (1)

I am using creatio API to get the object collection data from Creatio, in which lookup values have Ids. I want to replace those Ids with their Name saved in look ups. 

@Community, My question is, how can I get data of specific look up from Creatio using creatio API Odata4

Like 0

Like

1 comments

Hello!

To get the data of a specific lookup you need to use the following request:

https://sitename.creatio.com/0/odata/Lookup(lookup_id)

If...MoreLess

Show all comments

Hello @Community,

I am using Creatio API OData4 to get the data from Creatio Object Collection.

I wanted to filter the data base on date and time. Is there a way to get only last 3 months data with Odata4?

Like 0

Like

1 comments

Hello,

You can use the following filtering:
$filter=CreatedOn ge 2024-08-05T00:00:00Z

https://documenter.getpostman.com/view/10204500/SztHX5Qb?version=latest

Show all comments

Hello community!

I'm trying to filter contacts by unique keys from another system.

Currently, we are using 'eq' and 'or', but that has a limitation (the error states that only 100 nodes are supported in a filter).

After reading the oData 4.01 documentation that is linked in the creatio documentation...MoreLess

Like 0

Like

4 comments
Best reply

Hello,

The 'in' operator is not supported in OData 4 in Creatio.
At the moment, it is possible to use the operators that are available in the...MoreLess

Show all comments (3)

Hi All. 
Is there a way to pass a display value in odata rather then the GUID for the lookup values? 
 

Like 0

Like

1 comments

Hello Yuriy,
 

Let's try to do this on the example of the Contact object using the OData protocol version 4.0.

For the Contact object, in...MoreLess

Show all comments

I am looking to filter an odata request within power automate to return only records where the modifiedon date is greater than a specified value. I have thus far tried the following without success:

$filter=ModifiedOn%20gt%20datetime'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message":...MoreLess

Like 0

Like

2 comments

This works for me

$filter=ModifiedOn gt 2024-05-14T00:00:00Z

I don't know if there is something specific for power automate, but in just accessing...

MoreLess

Show all comments (1)

Hi Community,

We have a simple string field in one of our Creatio instances that is not being updated (tested with a Supervisor user).

Field is NOT being updated in the following scenarios

1- Frontend: When we save the record page.

2- Application Layer : The field is not being update from Bussines Processes...MoreLess

Like 0

Like

1 comments

Hello!

This means that there can be logic at the event layer level that changes the value of this field when saving a record. It can be...MoreLess

Show all comments

Hi Community,

In the OData4 protocol the maxTopLimit parameter

defines the limit for the value in the maximum number of rows in the output (which is 20.000 records)

We are retrieving the data from the Accounts table which has around 40.000 records.

What is the workaround or fix for this scenario?

Sasor

Like 0

Like

1 comments
Best reply

You can use the $top and $skip parameters to retrieve the data in pages. 

For example: 

Page 1 (first 1000)

https://creatiourl/0/odata/contacts...MoreLess

You can use the $top and $skip parameters to retrieve the data in pages. 

For example: 

Page 1 (first 1000)

https://creatiourl/0/odata/contacts...MoreLess

Show all comments