How to get field values?

Follow

Bhavin Panchal

• January 21, 2016 11:58
• Edited

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

0

• 

  Ajmal v Hassainar

  • January 21, 2016 13:06

  Hi Bhavin,

  Here is the documentation for filter items using C#: http://podio.github.io/podio-dotnet/items/

   

  Thanks

  Ajmal Vh <br/> Phases.dk

  0

  Comment actions Permalink
• 

  Bhavin Panchal

  • January 21, 2016 14:16
  • Edited

  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

  0

  Comment actions Permalink
• 

  Ajmal v Hassainar

  • January 21, 2016 14:20

  Please see the bottom of the documentation page, there will be a topic named Filters. Please use that examples.

  0

  Comment actions Permalink
• 

  Bhavin Panchal

  • January 22, 2016 08:01

  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

  0

  Comment actions Permalink
• 

  Ajmal v Hassainar

  • January 22, 2016 11:17

  Podio API does not support filtering with rich text fields [multi-line text fields]. 

  0

  Comment actions Permalink
• 

  Bhavin Panchal

  • January 25, 2016 07:36

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.