Issues with REST request running a table aggregation

Support, Troubleshooting, & Help
1

I’m working on building up a REST call from Highbyte to Tulip to return the results of a table aggregation. Everything was working up until I added the filters part of the URL which has special characters that need to be converted to a URL compliant % encoding.

Per the API docs, this is supported, but is not working for me. The error part of the message is:

filters=%255B%257B%2522field%2522%253A+%2522mkqih_disposition%2522%252C+%2522functionType%2522%253A+%2522notBlank%2522%257D%255D" 
status: Bad Request
 Raw response:
{"details":"Unable to parse query string: error parsing query value for `filters` as JSON: invalid character '%' looking for beginning of value","errorCode":"InvalidQueryString"}

The non-encoded version I’m passing with the filters option is:
[{"field": "mkqih_disposition", "functionType": "notBlank"}]

2

Try this one:

%5B%7B%22field%22%3A%20%22mkqih_disposition%22%2C%20%22functionType%22%3A%20%22notBlank%22%7D%5D

%25 leads to a % after decoding…

! # $ & ’ ( ) * + , / : ; = ? @ [ ]
%21 %23 %24 %26 %27 %28 %29 %2A %2B %2C %2F %3A %3B %3D %3F %40 %5B %5D
3

The encoding is being done by Highbyte, so it looks like I need to follow up with them.

Thanks!

4

Try URL Encode and Decode - Online (urlencoder.org)

On the very top you can switch between encoding and decoding