utf-8 encoding is unsupported in the API so it returns me error

Hey PriyaNandan,

The Description field in your payload is where youre getting the schema failure resulting in the error response.

The issue is following content " "Description" : "Test App1"" utf-8 doesnt recognise the circumflex above the A character.

Im guessing the extraction of the data from your data source is also pulling some markup along with the character from the spreadsheet.

There's various ways to sort this:

You could source the data from a .csv rather than .xls as .csv doesnt include any markup to drag out or you could change the datatype on the cells in your spreadsheet to 'text', rather than leave it as it is (which im guessing is set to -'general'). The problem with this approach is that just changing the type from 'general' to 'text' wont necessarily work. You can even try deleting the value out, change the type to 'text' and then type in your Description attribute value, however there is a known feature of excel that means that changing the type to 'text' only works if the cell hasnt already had any text in it. You might need to recreate the worksheet....brand new sheet, change the type to 'text' from 'general' and then type the value into the field.

Personally i dont bother using excel at all. I use text or csv files as my datasources as in my opinion using sprradsheets just adds a level of complication where something else can go wrong....like you current issue for example!

If i were you, id convert my .xls to .csv. this will automatically strip out the markup (which is what i think is the cause of your problem) cos csv type doesnt support any of that, leaving only your data which conforms to utf-8

Cheers

Rich