Community
Showing results for 
Search instead for 
Do you mean 
Reply

ODATA select on customFIelds. How? When?

Copper Contributor
Posts: 87
Country: Netherlands

ODATA select on customFIelds. How? When?

The API can now do an ODATA search ($filter) on the customFields. yeah.

But I also like to $select them.

 

This does not work:

 

/api/contacts?$select=id, fullName,customFields/tav&$top=100

 

the customFields/tav syntax is the same for searching, which works:

 

 

/api/contacts?&$filter=contains(customFields/tav, 'Tobias')

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Employee
Posts: 38
Country: USA

Re: ODATA select on customFIelds. How? When?

Unfortunately, we do not support $select|$expand on custom fields yet.  There are some complexities to overcome using the $select|$expands for custom fields and it is in our backlog.  However,  we do support $select|$expands on other related objects, such as businessAddress and homeAddress.

 

api/contacts?$select=fullname,id&$expand=businessAddress

api/contacts?$select=fullname,id&$expand=businessAddress($select=state,city)

 

 

For custom fields the syntax will look something like this when we do implement this:

 

api/contacts?$select=fullname,id&$expand=customFields($select=spouse,user1,tav)

 

 

Copper Contributor
Posts: 87
Country: Netherlands

Re: ODATA select on customFIelds. How? When?

Hi Simon,

 

I knew about the address expand, that works indeed.

When do you guys have planned to have implemented the expand functionality on custom fields?

 

We have several clients who wants a contact list with fields in their web application, including custom fields (like kvk number, btw number, etc).

Now we solve these things by making our own Act! API, which allows us to do exactly what we want, but it's a bit reinventing the wheel off course and then it's not with a nice generic OData standard.

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Employee
Posts: 38
Country: USA

Re: ODATA select on customFIelds. How? When?

I will raise this issue (Issue #D-05704 Expand|Select on Custom Fields) to the product owner so I can get a timeline for you.

 

 

Copper Contributor
Posts: 87
Country: Netherlands

Re: ODATA select on customFIelds. How? When?

Am I correct that this still doesn't work on 1.0.202.0 ?

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Employee
Posts: 38
Country: USA

Re: ODATA select on customFIelds. How? When?

That is correct, it is still not implemented.  The issue is being worked this week.  Will keep you informed when the problem is resolved.

 

Sorry for the inconvenience

Copper Contributor
Posts: 87
Country: Netherlands

Re: ODATA select on customFIelds. How? When?

Is this working in the latest version?

And if yes, can this version of the API work with v19 ?

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Employee
Posts: 38
Country: USA

Re: ODATA select on customFIelds. How? When?

I was not able to get this into the latest release (API v225).  But now that Act v20 /w act.insights have been released, I can spend more time getting this in the build.  FYI:  All new releases of the API will support Act! v18.0 or greater.

Copper Contributor
Posts: 87
Country: Netherlands

Re: ODATA select on customFIelds. How? When?

Hi Simon,

 

thanks for your answer, good to know v18 is always supported.

 

Can you give an estimation on when it's implemented?

 

- Tobias

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands