My question: What factors determine the type of a dataflow transform in the api JSON data (e.g. GenerateTableAction, SQL, SqlAction)?
Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command:
Putting in the DataFlow id and a filepath returns a json file to that filepath. Within the json file, there is data concerning the "actions" used to build the dataflow (e.g. loading the datasets, transforming the datasets, and producing outputs). For example, the action of loading a dataset is labeled 'LoadFromVault' in the json data, and the output action is labeled 'PublishToVault'.
My confusion regards the labels assigned to the transform actions. My understanding is that there are two kinds of transforms one can use within the DOMO gui: Table or SQL. But within the json data, I have come across three different labels for the transform actions: 'GenerateTableAction', 'SQL', and 'SqlAction'. Furthermore, there are cases where an action that is a 'Table' action in the gui is labeled as a 'SQL' action in the json data.
So, what determines how these labels are assigned, and how do they differ from one another?