topic MongoDB Input - Collections in Alteryx Server Discussions

MongoDB Input - Collections

Scruse314 — Thu, 18 Nov 2021 15:03:01 GMT

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.

Re: MongoDB Input - Collections

fmvizcaino — Mon, 22 Nov 2021 15:16:12 GMT

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

Re: MongoDB Input - Collections

mathieuf — Sun, 14 May 2023 17:35:08 GMT

Hi @Scruse314,

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

Re: MongoDB Input - Collections

somervill — Tue, 30 Aug 2022 03:17:01 GMT

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?

Re: MongoDB Input - Collections

mathieuf — Tue, 30 Aug 2022 07:04:56 GMT

Hi @somervill,

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

Re: MongoDB Input - Collections

somervill — Tue, 30 Aug 2022 07:08:43 GMT

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!

Re: MongoDB Input - Collections

mathieuf — Tue, 30 Aug 2022 07:44:11 GMT

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:

Re: MongoDB Input - Collections

somervill — Tue, 30 Aug 2022 08:07:06 GMT

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