Filter by Key

Answered

Follow

Alan Alvarado

• September 21, 2015 20:43

I've been trying to filter a request by key. Following the example described in the Podio API Doc and using the Sandbox I am setting as value in the key field the following "654321;6" where 654321 is the field_id and 6 the value. As a result I got the following: Invalid value "{key}" (string): Invalid filtering key.

I will appreciate anybody's advise.

0

• 

  Andreas Garnæs

  • September 22, 2015 07:11

  Hi Alan,

  Could you share the code or API request (URL and post body) you're trying to make and the full response please?

  Thanks,
  Andreas

  0

  Comment actions Permalink
• 

  Alan Alvarado

  • October 02, 2015 18:27

  Hi Andreas,

  Sure the url it is https://api.podio.com/item/app/{app_id}/filter/ and the body it is
  {filters:{"fecha": {"start":"2015-09-1 ","end":"2015-09-3 "}}}

  0

  Comment actions Permalink
• 

  Andreas Garnæs

  • October 05, 2015 09:02

  Is fecha a date field? If so, please try the keys from and to as described at the bottom of this page (under the date header): https://developers.podio.com/doc/filters

  0

  Comment actions Permalink
• 

  Alan Alvarado

  • October 05, 2015 22:39

  Hi Andreas,

  I change the filter of my POST for the following: {filters:{"created_on": {"from":"{2015-10-1}","to":"{2015-10-5}"}}} my issue with this POST it is that it is retrieving data from 2015-9-23, that means that I have information from September. Any idea?

  0

  Comment actions Permalink
• 

  Andreas Garnæs

  • October 06, 2015 08:00

  That sounds weird. Would you be able to share the full HTTP request and response?

  0

  Comment actions Permalink
• 

  Alan Alvarado

  • October 06, 2015 16:11

  Thanks Andreas for your message, my fault, I was able to solve it. One thing only, the response retrieve 20 items (default) how can I increase it to 50? I have done this:

  {filters:{"created_on": {"start":"{date.startOfMonth}","end":"{date.endOfMonth}"}}},{"limit": 50}

  but I continue getting 20 items instead 50. Appreciate your help

  0

  Comment actions Permalink
• 

  Andreas Garnæs

  • October 06, 2015 18:16

  Your JSON looks malformed, it should be like this:

  {
    "filters": {
      "created_on": {
        "start": "{date.startOfMonth}",
        "end": "{date.endOfMonth}"
      }
    },
    "limit": 50
  }
  

  0

  Comment actions Permalink
• 

  Alan Alvarado

  • October 06, 2015 18:26

  Here is a link to the response and I got only 20 items http://www.jsoneditoronline.org/?id=eb8fadaf70272352eeb45f82e22a5936

  0

  Comment actions Permalink
• 

  Andreas Garnæs

  • October 07, 2015 07:46

  Could you share your full request please? Have you set the Content-Type header to text/json?

  0

  Comment actions Permalink
• 

  Alan Alvarado

  • October 08, 2015 17:17

  It was my fault on the headers, now it is working. Thanks!

  0

  Comment actions Permalink
• 

  Alan Alvarado

  • October 08, 2015 18:05

  Hi Andreads,

  Using the same function, am I able to get specific fields? In order to minimize the transferred data between each request to Podio.

  Thanks!

  0

  Comment actions Permalink
• 

  Andreas Garnæs

  • October 09, 2015 07:27

  You can add the query parameters view=x and fields=y to the URL to control the JSON output. Try for example view=mini&fields=comments,comment_count. view controls what included by default, and then fields let you specify a comma-separated list of fields to additionally include.

  0

  Comment actions Permalink

Please sign in to leave a comment.