Excel Tools - fn!queryappianlogs constructing SQL statement where the column heading on the CSV contains a space value

Hi

Has anyone tried using the queryappianlogs function where the target file CSV has a space value in the headings ? I'm trying to convert the hc-plugins.csv file into a CDT so I can persist it into a database for all of our developers to see which Plug Ins and functions / smart services are available for use, but am failing at the first hurdle. 

If hints / tips would be very much appreciated. 

Regards

Paul

(Code snippet and output follows)

local!plugInCSVData: fn!queryappianlogs(
  sqlStatement: "select * from hc-plugins"
)

SAMPLE OUTPUT 

Dictionary
            Module Class: "EnumerationModuleDescriptor"
            Plugin Name: "Content Expressions"
            Module Key: "delete-type"
            Plugin Key: "com.appiancorp.cloud.plugins.contentfunctions"
            Plugin Version: "1.1.2"
        Dictionary
            Module Class: "EnumerationModuleDescriptor"
            Plugin Name: "Content Expressions"
            Module Key: "objects-to-delete"
            Plugin Key: "com.appiancorp.cloud.plugins.contentfunctions"
            Plugin Version: "1.1.2"
        Dictionary
            Module Class: "FunctionCategoryModuleDescriptor"
            Plugin Name: "Content Expressions"
            Module Key: "customContentFunctionsCategory"
            Plugin Key: "com.appiancorp.cloud.plugins.contentfunctions"
            Plugin Version: "1.1.2"
            
END RESULT LOOKING FOR 

CDT array of 

plugInKey
plugInName
plugInVersion
plugInModuleKey
plugInModuleClass

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data