API Query connection options failing to parse as expected with a semicolon or comma

Matillion ETL
1

Hi All,

 

I am unable to exploit an API using conditions due to, what I believe, API Query connection options failing to parse the conditional logic defined.

 

As an example, the API allows you to specify a start and end date as follows:

 

query=startDate=ge=2019-05-01T00:00:00Z;endDate=lt=2019-06-01T00:00:00Z

 

This works just great in Postman, but it appears anything after the semicolon is not evaluated. The API used the semicolon as a conditional AND ,where a comma is a conditional OR, also failing to work as expected but working in Postman as shown.

 

The query string is placed in 'Other' in the API connection options.

 

Any help or advice would be amazing.

 

Take care

 

2

the previous was incorrect to how applied, the following is the query applied and working in Postman, though not in Matillion

 

query=creationDate=gt=2021-09-27T00:00:00Z;creationDate=lt=2021-09-28T00:00:00Z