Solved

API calls and OData alias

Forum|Forum|8 months ago
March 25, 2025
5 replies
79 views

A

+1

AndersHallberg
Do Gooder (Customer)

Hi,

I’m trying to call this API to get data for multiple countries and attributes in one call:

/AttributeValueHandling.svc/AccountingAttributeSet(Company='{Company}',Attribute='{Attribute}')/AccountingAttributeValueArray

I’ve tried to use OData alias without succes:

/AttributeValueHandling.svc/AccountingAttributeSet(Company=@comp,Attribute=@attr)/AccountingAttributeValueArray?@comp=["1","2","3","4"]&@attr=["A","B","C"]

Is there some way to get this to work in one call? Using alias or some other way?

Best regards

Best answer by dsj

Hi @AndersHallberg

I don’t think it’s allowed to have multiple values in the path parameters.

May be the reference for AccountingAttributeValue could give you the same results you wanted?

Eg:

AttributeValueHandling.svc/Reference_AccountingAttributeValue?$filter=((Company eq '1' or Company eq '2') and (Attribute eq 'A' or Attribute eq 'B'))

+32

Mathias Dahl
Superhero (Employee)
Forum|Forum|8 months ago
March 25, 2025

I have never heard about that being possible, so you have to do one call per company and attribute, in this case. It's because of the nature of this page being a master/detail page. If there had been a list page will all attributes, that could have been used.

/Mathias

A

Like

+32

Mathias Dahl
Superhero (Employee)
Forum|Forum|8 months ago
March 25, 2025

PS. Perhaps you can create a simple query in Query Designed to get the data you want, and then use the resulting projection that should be created to support it?