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","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","postTime":"2021-02-09T11:27:53.811-08:00","lastPublishTime":"2021-02-09T11:27:53.811-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":2151},"placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"readOnly":false,"editFrozen":false,"body@stringLength":"1956","rawBody":"Hey ,
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","customFields":[],"repliesCount":1},"ModerationData:moderation_data:212928":{"__typename":"ModerationData","id":"moderation_data:212928","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Rank:rank:26":{"__typename":"Rank","id":"rank:26","position":9,"name":"Community Hero","color":"00537C","icon":null,"rankStyle":"OUTLINE"},"Revision:revision:212928_1":{"__typename":"Revision","id":"revision:212928_1","lastEditTime":"2021-02-09T12:31:45.010-08:00"},"QueryVariables:ReplyList:message:212928:1":{"__typename":"QueryVariables","id":"ReplyList:message:212928:1","value":{"id":"message:212928","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1749758931278":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1749758931278","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1749758931278":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1749758931278","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/common/ExternalLinkWarningModal-1749758931278":{"__typename":"CachedAsset","id":"text:en_US-components/common/ExternalLinkWarningModal-1749758931278","value":{"title":"Leaving the Community","description":"You're about to leave this site and navigate to an external domain. Are you sure you want to continue?","action.submit":"Continue","action.cancel":"Go Back"},"localOverride":false},"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1749758931278":{"__typename":"CachedAsset","id":"text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1749758931278","value":{"errorTitle":"Failed!","previewFile":"Preview File","downloadFile":"Download File {name}","removeFile":"Remove File {name}","errorBadExtension":"This file does not have a valid extension. \"{extensions}\" are the valid extensions.","errorFileEmpty":"This file is empty or does not exist.","errorTooLarge":"The maximum file size is: {maxFileSize}.","errorTooMany":"Too many attachments. The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1749758931278":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1749758931278","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1749758931278":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1749758931278","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"readyapi-questions","messageSubject":"utf-8-encoding-is-unsupported-in-the-api-so-it-returns-me-error","messageId":"212915","replyId":"212928"},"buildId":"3XH0qYWYCnEYycuN5W4S8","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","surveysEnabled":true,"openTelemetry":{"clientEnabled":false,"configName":"smartbear","serviceVersion":"25.4.0","universe":"prod","collector":"http://localhost:4318","logLevel":"error","routeChangeAllowedTime":"5000","headers":"","enableDiagnostic":"false","maxAttributeValueLength":"4095"},"apolloDevToolsEnabled":false,"quiltLazyLoadThreshold":"3"},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["components_seo_QAPageSchema","components_community_Navbar_NavbarWidget","components_community_Breadcrumb_BreadcrumbWidget","components_messages_TopicWithThreadedReplyListWidget","components_messages_MessageListForNodeByRecentActivityWidget","components_messages_RelatedContentWidget","components_customComponent_CustomComponent","components_messages_MessageView_MessageViewStandard","components_messages_EscalatedMessageBanner","shared_client_components_common_List_UnstyledList","components_messages_MessageView","components_messages_MessageView_MessageViewInline","shared_client_components_common_Pager_PagerLoadMore","components_customComponent_CustomComponentContent_TemplateContent","shared_client_components_common_List_UnwrappedList","components_attachments_AttachmentView","components_attachments_AttachmentView_AttachmentViewChip"],"appGip":true,"scriptLoader":[]}