Hi Ankur,
I did make the changes based on your code, yet when the feed file is being generated it is coming with empty values and the Variable Labels of those fields which we haven't selected while creating the Request.
Please find the below code :-
var ritmSysId = current.sys_id;
var set = new GlideappVariablePoolQuestionSet();
set.setRequestID(ritmSysId);
set.load();
var vs = set.getFlatQuestions();
var valuesArray = [];
var csvHeader = [];
var regularVariables = ['Application Name', 'Splunk Index name', 'Host', 'Log Location', 'Environment', 'Source Types', 'Please enter keywords for your logs for tagging purpose', 'Is there any sensitive information in your logs?', 'Please enter a description and usage of the logs you are onboarding to Splunk', 'What do you intend to use Splunk for with the logs you are ingesting?'];
var openshiftVariables = ['Application Name', 'Splunk Index name', 'Openshisft Namespace name', 'Please enter keywords for your logs for tagging purpose', 'Is there any sensitive information in your logs?', 'Please enter a description and usage of the logs you are onboarding to Splunk', 'What do you intend to use Splunk for with the logs you are ingesting?'];
var arrayUtil = new ArrayUtil();
for(var i=0;i<vs.size();i++){
var variableLabel = vs.get(i).getLabel();
var variableValue = vs.get(i).getDisplayValue();
var variableName = vs.get(i).getName();
if(variableLabel != 'Requested For' && variableLabel != 'Opened By' && variableLabel != 'Splunk Application'){
if(variableLabel == 'Regular new application logs onboarding' && arrayUtil.contains(regularVariables, variableLabel)){
csvHeader.push(variableLabel.toString());
valuesArray.push(variableValue.toString());
}
else if(variableLabel == 'Openshift logs onboarding' && arrayUtil.contains(openshiftVariables, variableLabel)){
csvHeader.push(variableLabel.toString());
valuesArray.push(variableValue.toString());
}
else{
csvHeader.push(variableLabel.toString());
valuesArray.push(variableValue.toString());
}
}
}
var csvHeaderRow = csvHeader.toString();
var valueRow = valuesArray.toString();
var sa = new GlideSysAttachment();
var document = csvHeaderRow + "\n" + valueRow;
var ritmRec = new GlideRecord('sc_req_item');
ritmRec.get(ritmSysId);
sa.write(ritmRec, "splunk.csv", "test/csv", document);
The Output I am getting:-
Thanks,
Angshuman
