Post

3 followers Follow
0
Avatar

How to get field values?

Hello,

One of the our client need dynamic report using API. There are four parameters 1. Organization 2. Space 3. Application and 4. Fields.

I have found values for all parameters. Now, I want to know that how to get values for selected filed? I have tried "ItemService.FilterItems" I have received all fields with values but, I want to filter this like say need to add "where condition" same as SQL query. Below is my code. 

FilterOptions filterOptions = new FilterOptions();
filterOptions.SpaceId = iSpaceId;
filterOptions.Limit = 500; Maximum number for this ?
filterOptions.Filters = string.Format("FieldId:{0}",iFieldId); I don't know how to use this filter. Please help

PodioAPI.Utils.PodioCollection<Item> item = PodioClient.ItemService.FilterItems(iAppId, filterOptions);

When I run this code throw an error. Please find below image for error.

I need selected field values not all.

Can anybody help me please?

Bhavin Panchal

Bhavin Panchal

Please sign in to leave a comment.

6 comments

0
Avatar

Hello Ajmal,

Thanks for the quick response. I have tried below thing but still facing same an error.

var item1 = PodioClient.ItemService.GetItemByExternalId(14645800, "legal-name");

Please help.

Bhavin Panchal

Bhavin Panchal 0 votes
0
Avatar

Hello Ajmal,

I have gone through the document. Error was gone but not able to pull data.

Here I need to understand what is numberFieldId and textFieldId?

Is it FieldId which we are getting from podio.ApplicationService.GetApp(iAppId)?

I tried below thing but get zero item in filteredItems.

Actually I want below thing with filter.

Can you please help me how I get this value?

Bhavin Panchal

Bhavin Panchal 0 votes
0
Avatar

Hello Ajmal,

Can we filter Field ID? First I need to filter Field ID which is 112317280 then after I want get value from filtered field.

Is this possible ?

Bhavin Panchal

Bhavin Panchal 0 votes