How to Pass Dynamic Date value to MongoDB table

[mrammail]

Hello Everyone!

I am using MongoDB Input Tool to connect the MongoDB database. And I want to pass the date value to the table in the Input Tool Dynamically. And the date column showing as String, but I want to pass the date value as the date format. I tried using the JSON format but it works for one value by hardcoding. But I want to pass this dynamically by selecting the value from another stored table.

1. MongoDB Input Tool

2. Pass the date as a dynamic Input

3. Extract the records from the MongoDB table based on this date value

Please share your thoughts, I would appreciate your help on this matter.

Thanks

Ramachandran

[RishiK]

@mrammail can you try to use the Dynamic Input tool to pass through the dynamic SQL?

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Modifying-SQL-Query-using-the-Dynam...

[mrammail]

Hello RishiK,

Thanks for your response. This will work for general database connections. But I am looking for MongoDB connection. Please check the attached image. I want to pass the 20200911 as dynamically.

Thanks

Ram

Spoiler

[RishiK]

@mrammail ah I get you now. You can update these parameters via the Interface tools. I knocked up a quick example:

You can then run your workflow as an app in Designer:

or on Server if you have Alteryx Server

[mrammail]

Thank you. I will check this further and let you if any questions.