Hi, everyone! I need to import a spreadsheet data into a database table and I'm using Import Excel to Database smart service for that matter with parameters described below:
So basically excel header names I got from a document are in respective order as database field names. Also there are other database columns which I'm populating with other data than spreadsheet. The problem is that a smart service returns Error Occured = true, but no Error Txt. So I can't localize an issue
Discussion posts and replies are publicly visible
Additionally, strange issues from some of these services are why I always recommend using fn!readexcelsheetpaging() within an expression rule, instead of the service directly. This will allow much more flexibility and troubleshooting. The rule can use this function to read the document, and you can export a CDT after any data manipulations, then plug it into the standard Write to Datastore service.
Excel Tools