Using the MongoDB I am trying to produce a list of Collections and the Workflows/Objects that fall under each Collection. Desired Output: (Example) CollectionIdName OwnerIdDateAddedApp/Object Name1Collection 1123DD-MM-YYYYWorkflow 11Collection 1123DD-MM-YYYYWorkflow 22Collection 2456DD-MM-YYYYWorkflow 32Collection 2456DD-MM-YYYYWorkflow 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.

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 mongo test.yxmd

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:

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! mongotest.yxwz

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.

Server

MongoDB

Accepted answers

All comments

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

Collections.yxmd

Server output.pdf

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703