Now that we have a working Bulk Uploader, let's try and make it a little more robust. To do this, we'll incorporate the GlideExcelParser into our process. This will gave us a tool to get a sneak peek at the Excel attachment before it is saved to the request or copied over to the Data Source record.The background on this API is located here.
I did a quick search in the default script includes already in the system and found an example of GlideExcelParser being used here. It's always nice to find some examples of it already coded out to use as a starting point. This is the same type of thing we'll look to do as we analyze the information a user may request as a part of our form.
Looking at the documentation for the API, there are a calls to get header information as well as individual rows associated with the spreadsheet. We can analyze individual cells by getting the column headers, then doing a getRow().
All of this will be useful to build out a couple of use cases to make sure we're getting good data into the system. As a couple of examples, I'll try and set this up both as a server side check and then client side through an Glide AJAX call.
