\nSpiro Taleski
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"112","kudosSumWeight":1,"repliesCount":0,"postTime":"2022-01-12T14:37:21.003-08:00","lastPublishTime":"2022-01-12T14:37:21.003-08:00","metrics":{"__typename":"MessageMetrics","views":3620},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:8257":{"__typename":"ModerationData","id":"moderation_data:8257","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:8257":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:1563"},"id":"message:8257","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:8252/message:8257","revisionNum":1,"uid":8257,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:8252"},"conversation":{"__ref":"Conversation:conversation:8252"},"subject":"Re: Get current JSON document being inserted","moderationData":{"__ref":"ModerationData:moderation_data:8257"},"body":"I had to do this JSON.stringify($original), but that worked. Using $original caused insertion problems into a varchar2 or clob because it wasnt the same datatype. But, your recommendation to put it in the mapper snap of the error pipeline worked out great because I only had to change the one error pipeline and not all 20 or so pipelines that call the error pipeline. Thanks
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":1,"repliesCount":0,"postTime":"2022-01-13T06:53:10.411-08:00","lastPublishTime":"2022-01-13T06:53:10.411-08:00","solution":true,"metrics":{"__typename":"MessageMetrics","views":4633},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:8254":{"__typename":"ModerationData","id":"moderation_data:8254","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:8254":{"__typename":"ForumReplyMessage","uid":8254,"id":"message:8254","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:8252/message:8254","revisionNum":1,"author":{"__ref":"User:user:1563"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:8252"},"conversation":{"__ref":"Conversation:conversation:8252"},"subject":"Re: Get current JSON document being inserted","moderationData":{"__ref":"ModerationData:moderation_data:8254"},"body":"I put $original as the expression populating a error pipeline parameter in the pipeline properties of the pipeline. When I run the pipeline the pipeline complains “Reason: Value referenced in the sub-expression ‘$original’ is null”. ?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2022-01-13T05:46:21.766-08:00","lastPublishTime":"2022-01-13T05:46:21.766-08:00","metrics":{"__typename":"MessageMetrics","views":3620},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:8255"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:8255":{"__typename":"ModerationData","id":"moderation_data:8255","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:8255":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1049"},"id":"message:8255","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:8252/message:8255","revisionNum":1,"uid":8255,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:8254"},"conversation":{"__ref":"Conversation:conversation:8252"},"subject":"Re: Get current JSON document being inserted","moderationData":{"__ref":"ModerationData:moderation_data:8255"},"body":"\nThat will not work.
\nThe main pipeline will propagate the error message(containing the error details along with original data) to the linked error pipeline.
\nIn the error pipeline using Mapper Snap you can access all the fields from the error message.
\nAdd Mapper Snap at error pipeline level and try to access the $original object.
\nIf that will not work, please share the sample pipelines.
\nRegards,
\nSpiro Taleski
I have a mapper in the erorr pipeline. Let me try that.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"58","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-01-13T06:09:06.948-08:00","lastPublishTime":"2022-01-13T06:09:06.948-08:00","metrics":{"__typename":"MessageMetrics","views":3621},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:8252"},"solution":{"eq":true}},"sorts":{"postTime":{"direction":"ASC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":false,"useBody":true,"useKudosCount":false,"useTimeToRead":false,"useMedia":true,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":true,"useTags":false,"useUserHoverCard":false,"useNodeHoverCard":false,"usePreviewSubjectModal":false,"useMessageStatus":false}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1750955846246","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1750955846246","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1750955846246","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1750955846246","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1750955846246","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1750955846246","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1750955846246","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1750955846246","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1750955846246","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1750955846246","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolutionList-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1750955846246","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListMenu-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListMenu-1750955846246","value":{"postTimeAsc":"Oldest","postTimeDesc":"Newest","kudosSumWeightAsc":"Least Liked","kudosSumWeightDesc":"Most Liked","sortTitle":"Sort By","sortedBy.item":" { itemName, select, postTimeAsc {Oldest} postTimeDesc {Newest} kudosSumWeightAsc {Least Liked} kudosSumWeightDesc {Most Liked} other {}}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1750955846246","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-shared/client/components/common/Pager/PagerLoadMore-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1750955846246","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1750955846246","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1750955846246","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1750955846246","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/common/ExternalLinkWarningModal-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/common/ExternalLinkWarningModal-1750955846246","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}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"pipelines","messageSubject":"get-current-json-document-being-inserted","messageId":"8252"},"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_messages_ThreadedReplyList","components_external_components_ExternalComponent","components_community_FooterWidgetHelpLink","components_community_KhorosLogo","components_messages_EscalatedMessageBanner","shared_client_components_common_List_UnstyledList","components_messages_MessageView","shared_client_components_common_Pager_PagerLoadMore","shared_client_components_common_List_ListGroup","components_messages_MessageView_MessageViewInline","components_customComponent_CustomComponentContent_TemplateContent"],"appGip":true,"scriptLoader":[]}