• 

  Jeff Hickey

  • July 21, 2023 20:15

  Hi Adeb, if you're looking to get the IDs of datasets within a Wdata Table, you can use the List Files command for this. You must specify the Table ID to configure this command. It will return a list of files in the table, including the IDs of the files.

  0
• 

  Abed Alsa'di

  • July 21, 2023 20:27

  Thanks Jeff! one more question though, how exactly do you extract the ID after using the list files command

  0
• 

  Jeff Hickey

  • July 22, 2023 02:44

  The List Files command returns a JSON object of files in the Wdata Table. You could use a Group Node to iterate over the list of files and perform actions on them. Or you could filter and retrieve a specific file itself. One way to do this would be to Convert JSON to CSV and then use Smart Filter Rows to isolate the specific file you need.

  Also, I wanted to provide a few helpful links. This website https://support.workiva.com/hc/en-us/categories/360002307351-Working-in-Wdata is a great resource to reference while developing Chains. It is full of documentation on the subject. Additionally, I recommend the following training courses that are also great resources to help learn about the Data Management Suite:

  1. Introducing the Data Management Suite
  2. Data Management: Using Wdata
  3. Data Management: Using Chains & Data Prep

  0

Please sign in to leave a comment.