Hi Ankur,
Thanks for your response to this post. I think I have what you suggested in my version of this however this is not quite working for me (yet) and I am getting an error. I am trying to do this from a scoped app but global doesn't seem to work for me either. Here is what I have done.
1. I uploaded a file to the mid server named "Positions.csv" under a subfolder called "import"
2. I created a scheduled script execution with the following code:
var probe = SncProbe.get("Command");
probe.setName("cd /SNow MidServer Info/agent/import && cat Positions.csv | base64");
probe.create("DVMidServer"); // give mid server name here which is up and running3. I created a business rule (tried this with both scoped and global) with the following parameters:
Condition: Queue is input AND State is ready
Script: I changed the name to "Positions.csv" and the source to point to the data source sys_id. My intention was to attach the file to the data source so that the corresponding transform would run.
var base64encodedData = ''; // after parsing this will contain the base64encoded data
var s = new sn_ws.SOAPMessageV2('Attachment Creator', 'insert');
s.setStringParameter('agent','AttachmentCreator');
s.setStringParameter('name','Positions.csv:text/csv');
s.setStringParameter('source','sys_data_source:d5f55855db26c410fc0075131f961928');
s.setStringParameter('payload',base64encodedData);
s.setStringParameter('topic','AttachmentCreator');
var response = s.execute();4. My data source is as follows:
My intent with this is to:
1. Check for a new file daily on the mid server
2. Import the file to the instance
3. Run the desired transform and import data to the target
I am getting this error message so far but I also feel like I may be missing something else.
SOAP Msg Outbound - SOAPMessageClient : Exception initializing Soap Message functionAttachment Creator.insert Message: Unable to find SOAP Message Record with Name: Attachment Creator: no thrown errorI am using the Orlando version at the moment.
I am not sure if I am supposed to create a new SOAP message (I have no idea how to do this correctly). Here is a list of SOAP messages currently in the table:
Do you have any idea what I am doing wrong or what is missing?
