MongoDB Input - Collections

[Scruse314]

Using the MongoDB I am trying to produce a list of Collections and the Workflows/Objects that fall under each Collection.

Desired Output: (Example)

CollectionId	Name	OwnerId	DateAdded	App/Object Name
1	Collection 1	123	DD-MM-YYYY	Workflow 1
1	Collection 1	123	DD-MM-YYYY	Workflow 2
2	Collection 2	456	DD-MM-YYYY	Workflow 3
2	Collection 2	456	DD-MM-YYYY	Workflow 4

I have read the documentation in the link below but I'm not still not sure how to proceed it getting the desired output. By Default the MongoDB outputs all nested values from the JSON string into columns but I want tall the nested values as rows.

http://downloads.alteryx.com/betawh_xnext/MongoInput.htm

Any help or assistance would be greatly appreciated.

Thank you.

[fmvizcaino]

Hey @Scruse314 ,

I suggest you download the Usage Report from the licensing portal. There you will have many examples of interactions between MongoDB collections but also showing how to parse the output properly.

Best,

Fernando Vizcaino

[mathieuf]

Hi @Scruse314,

A bit messy and not well organized but this should help you

[somervill]

This is super helpful Mathieuf! Is this tool may also able to drag collection from a self built mongo db? Namely from a mongo db server not a local server?

[mathieuf]

Hi @somervill,

Yes you should be able to connect to any MongoDB. You might need to change the inputs to match your needs.

[somervill]

Thanks mathieuf!

I currently bumped into an new issue. The workflow is able to perform on a Alteryx v2019 version while not able to work on v2022.

I've attached the sample workflow, really appreciate if you may have a look!

[mathieuf]

I would try to have a simple workflow to start and not an app.

Also try to input user, password into the fields, like below:

[somervill]

Yeah, I tried that however it just seems not works on the 2022 version, not quite sure about this. Also have a regualr workflow attached