Embedded card via programmatic filters does not allow BETWEEN pfilters

user033119
user033119 Member
in APIs & Domo Developer

We changed our integration to use Programmatic Filters for authentication. That part works just fine. It is when I apply additional pfilters via the query parameter, the embedded card fails to load.

Its that Date column again, which is a calculated field, with the BETWEEN filter. the final url with the POST to domo server with embedToken set is https://public.domo.com/cards/{RANDOMID}?pfilters=%5B%7B%22column%22:%22companyid%22,%22operand%22:%22IN%22,%22values%22:%5B116%5D%7D,%7B%22column%22:%22uniqueformid%22,%22operand%22:%22IN%22,%22values%22:%5B%22307%22%5D%7D,%7B%22column%22:%22Date%22,%22operand%22:%22BETWEEN%22,%22values%22:%5B%222020-10-01%22,%222020-12-31%22%5D%7D,%7B%22column%22:%22tagvalue16%22,%22operand%22:%22IN%22,%22values%22:%5B%22automation123Gijs%22%5D%7D%5D&dap=10298 If I remove the Date column, it seems to work correctly.

We obviously need to have that date column there to use it for BETWEEN filtering.

Anyone has experienced this issues as well?

Comments

  • GrantSmith
    GrantSmith Coach

    Hi @user033119 

     

    I haven't used programmatic filters extensively and haven't run into your specific issue but have you tried translating the BETWEEN to be >= and <= clauses to see if that's an issue?

     

    For example:

    `date` BETWEEN `date1` AND `date`  becomes `date` >= `date1` AND `date` <= `date2`

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • user033119
    user033119 Member

    We tried that as well. Not working. It is difficult to understand why this is a bad request as there is zero information on the error and status.

  • GrantSmith
    GrantSmith Coach

    Are you able to filter on another date field which isn't a beast mode? Can you try and calculate that date in a dataflow first and then do the filtering so it's not relying on the beast mode?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    are you able to successfully filter on Date is IN ?  (i.e. do you have the syntax for specifying a date correct?)

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.

Categories