How to pass mapper column in Rest API filter condition
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-04-2020 05:20 AM
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 someone can advice here.
Created gt datetime’" + $CREATED + "’
if i hardoce the date value it is working — Created gt datetime’2020-04-02T11:00:00’
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-04-2020 10:35 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-04-2020 11:36 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-05-2020 12:44 AM
Hi Howard,
Thanks for the help and input.
It worked when I use the Oracle Select Snap, instead of Oracle Execute.
I am very great ful for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-05-2020 07:49 AM
No problem. Glad it is working.
Just an FYI, disabling the first snap In a branch of snaps will disable all downstream snaps as well. So, for that branch in your screenshot of all disabled snaps, you can just disable the first one and have the same effect. Just to save you time from disabling and enabling all of them.