Hello Community Folks,
I've been trying to modify or re-structure the json payload that I'm getting using mapper snap. But I'm finding difficulty achieving it.
Source JSON is -->
Thank you so much bojanvelevski, you were spot on there. This helped a great deal with an example of the solution as well and I think it's elegant solution as well as it is very clearly outlined and easier to understand.
","body@stringLength":"424","rawBody":"Thank you so much
Hi hasmukhp27
What you need is a JSONSplitter snap set to split the entity arrays. The rest is easy, the output documents contain the data you need, and you just need to map it accordingly.
Regards,
Bojan
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"208","postTime":"2023-12-20T07:21:47.737-08:00","lastPublishTime":"2023-12-20T07:21:47.737-08:00","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuNHwyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/images/bS0yNDYyMS02MDU4aUQ5NDNFRUJENkRBMjhFMzY?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuNHwyLjF8b3wyNXxfTlZffDI","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/images/bS0yNDYyMS02MDU5aTlGMjFEOTdGQjZCRUY0NEY?revision=1\"}"}}],"totalCount":2,"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":2993},"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,"customFields":[]},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1750955844577","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1750955844577","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/common/ExternalLinkWarningModal-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/common/ExternalLinkWarningModal-1750955844577","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},"QueryVariables:ReplyList:message:14044:1":{"__typename":"QueryVariables","id":"ReplyList:message:14044:1","value":{"id":"message:14044","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}},"ForumReplyMessage:message:14044":{"__typename":"ForumReplyMessage","id":"message:14044","customFields":[],"entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:14043/message:14044","revisionNum":1,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"parent":{"__ref":"ForumTopicMessage:message:14043"},"repliesCount":0,"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1502":{"__typename":"User","id":"user:1502","entityType":"USER","eventPath":"community:iaudz84835/user:1502","deleted":false,"uid":1502,"login":"yash_verma","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-09-21T02:48:30.962-07:00"}},"ForumTopicMessage:message:14043":{"__typename":"ForumTopicMessage","uid":14043,"id":"message:14043","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:14043","revisionNum":1,"author":{"__ref":"User:user:1502"},"readOnly":false,"repliesCount":2}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"app_integration","messageSubject":"move-objects-structure-with-in-json","messageId":"24618","replyId":"24623"},"buildId":"8CqYPsxb5UG4aoIp8lqTz","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","surveysEnabled":true,"openTelemetry":{"clientEnabled":false,"configName":"snaplogic","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_customComponent_CustomComponent","components_community_FooterWidget","components_messages_MessageView_MessageViewStandard","components_external_components_ExternalComponent","components_community_FooterWidgetHelpLink","components_community_KhorosLogo","components_messages_EscalatedMessageBanner","shared_client_components_common_List_ListGroup","components_messages_MessageView","components_messages_MessageView_MessageViewInline","shared_client_components_common_Pager_PagerLoadMore","components_customComponent_CustomComponentContent_TemplateContent","shared_client_components_common_List_UnstyledList"],"appGip":true,"scriptLoader":[]}