Forum Discussion

pranil2k2's avatar
pranil2k2
Contributor
6 years ago

How to pass mapper column in Rest API filter condition

Hi, I have a requiremnet, where i need to pass the mapper Date column (which i read from oracle table) in REST API filter condition. i tried with below syntax, but it is giving error. please someon...
pranil2k2's avatar
pranil2k2
Contributor
6 years ago

Hi ,

I tried as you said, but it is giving same error as bad request.

My Pipeline is very simple. i am trying to read date column from Oracle table, passing it through mapper, and then using it in Rest Get filter.



  • cjhoward18's avatar
    cjhoward18
    Employee
    6 years ago

    Not sure what your rest endpoint is expecting, but to mimic the same value when hard coding the date you may need the single quotes like this:

    “Created gt datetime ‘“ + $CREATED + “‘“

    Where you are surrounding the value in $CREATED with single quotes similar to your hard coded string/date example