Community
Showing results for 
Search instead for 
Do you mean 
Reply

/api/metadata/fields incplete voor opportunities

Copper Contributor
Posts: 139
Country: Netherlands

/api/metadata/fields incplete voor opportunities

[ Edited ]

If i do a request to: 

https://demo.actweb.nl/Act.Web.API/api/metadata/fields?recordType=opportunity&$select=name

 

I get only these fieldnames back:

 

"name": "reason"
"name": "productTotal""name": "weightedTotal"
"name": "name"

"name": "customFields/exporterrors"
"name": "customFields/opportunity_field_8"
"name": "customFields/opportunity_field_6"
"name": "customFields/opportunity_field_7"
"name": "customFields/opportunity_field_4"
"name": "customFields/opportunity_field_5"
"name": "customFields/opportunity_field_2"
"name": "customFields/ordernr_snelstart"
"name": "customFields/opportunity_field_3"
"name": "customFields/opportunity_field_1"

 

But what about all the other fields like the status? the stage? actual- and estimated CloseDate?

If I do a request to a certain opportunity, I do get those fields back:

 

For example I'd like to filter in opportunities on their status (open/closed) an on their process/stage. How do I do this?

 

This does not work:

 

/api/opportunities?$filter=stage/id eq guid'9a704183-7eb3-4999-a053-4bb79e1564a7'

 

as I get this error back:

Unrecognized 'Edm.String' literal 'guid'9a704183-7eb3-4999-a053-4bb79e1564a7'' at '45' in 'contains(name, 'TestSync')   and stage/id eq guid'9a704183-7eb3-4999-a053-4bb79e1564a7''.

 

BTW this is on API 1.0.248.0.

 

Greetings,

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

Re: /api/metadata/fields incplete voor opportunities

Hello,

 

I just checked on this item as well, and this feature was fixed in the API in the last release, which was published last week on the download center or can be accessed by developer.act.com. 

 

Again, please let us know if you have any additional feedback or questions.

 

Regards,

Jeff Hanrahan

Copper Contributor
Posts: 139
Country: Netherlands

Re: /api/metadata/fields incplete voor opportunities

[ Edited ]

But I just installed that last update, and if I do a GET to this URL:

 

https://demo.actweb.nl/Act.Web.API/api/metadata/fields?recordType=opportunity&$select=name (which is on API version 1.0.259.0)

I get the fields listed below. No status. No stage. 

Also, and more importantly,  /api/opportunities?$select=name,id&$filter=stage/id eq guid'9a704183-7eb3-4999-a053-4bb79e1564a7' still does not work.

 

[
{
"name": "customFields/exporterrors"
},
{
"name": "customFields/opportunity_field_8"
},
{
"name": "reason"
},
{
"name": "productTotal"
},
{
"name": "customFields/mustsync"
},
{
"name": "customFields/opportunity_field_6"
},
{
"name": "customFields/opportunity_field_7"
},
{
"name": "customFields/opportunity_field_4"
},
{
"name": "customFields/opportunity_field_5"
},
{
"name": "customFields/opportunity_field_2"
},
{
"name": "customFields/ordernr_snelstart"
},
{
"name": "weightedTotal"
},
{
"name": "name"
},
{
"name": "customFields/opportunity_field_3"
},
{
"name": "customFields/opportunity_field_1"
},
{
"name": "customFields/exactorderid"
},
{
"name": "grossMargin"
},
{
"name": "competitor"
},
{
"name": "source"
}
]

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands