Comments

• To Query for an ACL: First, find the distinguished name using the following query: (&(objectCategory=group)(cn=nameOfACL)) Then, use this to query fr users in the ACL, as follows: (&(objectCategory=user)(memberOf=CN=nameOfACL,OU=O365 Groups,…

  in How do I query for users in active directory? Comment by andyvidan December 2019
• The Table Query Module uses SQLite syntax, so you can concat two strings using the || operator.

  in String concatenation in Table Query Module Comment by andyvidan October 2019
• Yes, this is an option. You just need to flip the below key in the web.config to True. We have a blog post on how it works underneath the hood. https://blog.composable.ai/2018/02/08/composable-with-https/.   <add key="RequireHttps" valu…

  in Forcing HTTPS on Composable Comment by andyvidan October 2019
• Open the DataFlow's overview page (if you are viewing the DataFlow in the Designer, click on More Details to get to the overview page). In the bottom right of the age, you will see a card where you can (as shown below), type in the Folder name or ad…

  in DataFlow Folders and Tags Comment by andyvidan October 2019
• Typically, the format for a string will take the form of {i,x} where i is the index and x specifies the alignment and formatting. For example, {0,12} means a right-aligned 12-character string, whereas {0,-12} means a left-aligned 12-character string…

  in Fixed Width Column Inputs - format and text alignment Comment by andyvidan October 2019
• Put the DataFlow ID in the DefaultValue column, and make the data type System.Int32 and the control type AppRun

  in Run a DataFlow from a DataPortal form UI Comment by andyvidan October 2019
• The above needs two fixes: In DayOfWeek, place an * there. (This means that regardless if it is a Sunday, Monday, Tuesday, …. it will run on the 4th of each month Change hour to 7. Valid input here are only 0-23 with no zero padding.

  in Timer not working Comment by andyvidan October 2019
• In your screenshot above, since you have a Table Cell Selector (and specifying the 1st Row with Row 0), it is only selecting that row and sending that file to the delete module. So you are only deleting a single file. You actually need to loop thro…

  in How can I loop through to delete all files in a directory? Comment by andyvidan October 2019
• All errors that occur during the DataFlow run are suppressed until after it completes. They are then thrown and the DataFlow receives a status of ‘completed with error.’ Any error handling is then applied after the error is thrown such as emails and…

  in What does ”Throw errors on dataflow completion" do? Comment by andyvidan October 2019
• The inputs on the Timer module are not being specified correctly. For the Minutes parameter, always make sure this is set in the range of 0 to 59. So for 7:00, it would be 0, and 7:05 it would be 5, etc. Think of it as if you are spcifying the actua…

  in Timer not working Comment by andyvidan October 2019
• CSV Reader is a robust Module for reading all types of delimited text files. While the Module itself only has the 3 most frequently delimiters as options, you can specify any delimiter you like, by using a String Input module: http://support.composa…

  in Specifying a unique CSV Reader delimiter? Comment by andyvidan October 2019
• Purpose: Help Annotate and Document DataFlows How to use: In the Designer, right click on the canvas to bring up the new context menu. Click on ‘Add a Comment’ http://support.composable.ai/uploads/567/H0BKCYFDN6CB.jpg Anew sticky note will appear: …

  in How do I use Sticky Notes in the Composable Designer? Comment by andyvidan October 2019
• For the CSV Reader (e.g., handles txt files), Composable treat all fields as text on import and you need to use the Table Column Type Module if you want it to import as another data type. For xlsx files (XLSX Reader), Composable provides more option…

  in What is the proper syntax for the CSV Reader module, column type? Comment by andyvidan October 2019
• There is a Fixed Width Format input module you can use, as follows: http://support.composable.ai/uploads/981/U7IZ7B80YO8L.jpg You can drag/drop these input modules from the module library on the left, or right click on the green dot of the file stre…

  in Specify data types for Fixed Width files Comment by andyvidan October 2019
• For the CSV Reader column types, you can use the Table Colum Type Input module to specify the types for one or more columns. (You can find this Module in the Module Library, or simply right click on the green input parameter, and this module should …

  in What is the proper syntax for the CSV Reader module, column type? Comment by andyvidan October 2019
• Modify the CSV reader module to start at Row 0, and also to set the column row as -1 http://support.composable.ai/uploads/307/SAGW671F0AGP.png Composable will then assign the column names as: col0, col1, col2, … You can follow this with a Table Quer…

  in CSV with no header line Comment by andyvidan October 2019