My API for the week : GlideTextReader !
Hi everyone, hope you are doing well.
I want to share with you a use case that I have encountered, which that the client want to sent a csv file to the midserver but wants to apport some data modification on that file using the Post-export script. basically he wanted to alternate two names of columns in the csv header.
Thought at first about using the database view, but unfortunately that will work only in case we were sending labels in the Headers of the csv file instead of the technical names.
So before I go in deep of what I did in terms of code, let me put here the blueprint that I have followed:
- Allow the first csv to get exported
- then in post export script i would do the following:
- I will get the content of the csv file by fetching the record from "sys_attachment" table
- Do the modification that I want and store in a string variable that will create my new csv file
- Replace the old csv file with the new one (*the attachment will be on the MidServer Attachement record (table is: ecc_agent_attachment))
- Then lastly, i will create a record on ecc_queue table with agent the midserver that I want , topic "StreamPipeline" , queue will be "output" , the state will be "ready" and lastly the Payload that will indicate the sys_id of the new attachment and the sys_id of the MID Server Attachment record where the attachment is
For reading the csv i used this code:
This code has come in very handy since at first I was using getBytes() methode which works only for files less than 5 mb, but this new code that uses streams of data I used it for a file with 12 mb. and it worked fine , the only thing that you will need to pay attention to afterwards is the string variable that you will use to create the csv file where you would want to store the data, keep in mind that "String object limit of 33554432 bytes" so you may want to do it in chunks.
So after doing the modifications that i want I created my csv file:
Then the last step is to create the ECC Queue record:
for the xml payload, it is as the following:
