\nTransaction Name=TRANSACTION
\nFirst Name=FNAME
\nLastName=LNAME
In addition, one file contains the id, the other contains the value. I need to combine these into an output with Instance (text value) and the ID value. I have a gate setup to create a doc with input0 and input1 as shown below.
\nInput0
\n“Instance”:“Transaction Name”
\n“ID”:“bae77”
Input1
\n“TRANSACTION”:“AC00014623”
What I want this to look like is:
\n{TextValue\":“AC00014623”
\n“Item”:{“id”:“bae77”}
I have about 40 of these pairs, slightly different in each file.
\nAny recommendations or ideas?
","body@stringLength":"870","rawBody":"I’m trying to produce output containing Value and Item ID from separate files.
\nI have two input files for this, with different naming for the fields For example,
\nTransaction Name=TRANSACTION
\nFirst Name=FNAME
\nLastName=LNAME
In addition, one file contains the id, the other contains the value. I need to combine these into an output with Instance (text value) and the ID value. I have a gate setup to create a doc with input0 and input1 as shown below.
\nInput0
\n“Instance”:“Transaction Name”
\n“ID”:“bae77”
Input1
\n“TRANSACTION”:“AC00014623”
What I want this to look like is:
\n{TextValue\":“AC00014623”
\n“Item”:{“id”:“bae77”}
I have about 40 of these pairs, slightly different in each file.
\nAny recommendations or ideas?
","kudosSumWeight":0,"postTime":"2020-08-19T20:41:21.019-07: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":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuNHwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:mapper","text":"mapper","time":"2023-07-25T02:37:05.869-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:6472_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":13390},"read":false,"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"searchSnippet":"I’m trying to produce output containing Value and Item ID from separate files. \n I have two input files for this, with different naming for the fields For example, \nTransaction Name=TRANSACTION \nFi...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"AcceptedSolutionMessage:message:6481"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mg","node":{"__ref":"ForumReplyMessage:message:6473"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mw","node":{"__ref":"ForumReplyMessage:message:6474"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8NA","node":{"__ref":"ForumReplyMessage:message:6475"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8NQ","node":{"__ref":"ForumReplyMessage:message:6477"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Ng","node":{"__ref":"ForumReplyMessage:message:6479"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Nw","node":{"__ref":"ForumReplyMessage:message:6480"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:6472":{"__typename":"Conversation","id":"conversation:6472","solved":true,"topic":{"__ref":"ForumTopicMessage:message:6472"},"lastPostingActivityTime":"2020-08-29T08:15:06.848-07:00","lastPostTime":"2020-08-29T08:15:06.848-07:00","unreadReplyCount":10,"isSubscribed":false},"ModerationData:moderation_data:6472":{"__typename":"ModerationData","id":"moderation_data:6472","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:6472_1":{"__typename":"Revision","id":"revision:6472_1","lastEditTime":"2020-08-19T20:41:21.019-07:00"},"CachedAsset:theme:customTheme1-1755250099229":{"__typename":"CachedAsset","id":"theme:customTheme1-1755250099229","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"webicon-1744319537585.png","imageLastModified":"1744319538967","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"snaplogic-rgb-cropped-1744295700098.png","imageLastModified":"1744295701820","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1350px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"20px","paddingXLg":"32px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"NONE","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"#006EF5","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","defaultMessageFontFamily":"var(--lia-bs-font-family-base)","forumColor":"#4099E2","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#148563","blogColor":"#1CBAA0","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#4C6B90","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#003399","secondary":"#333333","bodyText":"#0E1831","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FFD700","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#2DA493","#FF0083","#006EF5","#FFD700","#F26D0E","#182852","#E7F5FF"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Poppins","fontStyle":"NORMAL","fontWeight":"500","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","tableBgColor":"transparent","tableBorderColor":"var(--lia-bs-gray-700)","tableBorderStyle":"solid","tableCellPaddingX":"5px","tableCellPaddingY":"5px","tableTextColor":"var(--lia-bs-body-color)","tableVerticalAlign":"middle","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"Roboto","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"GOOGLE","name":"Poppins","styles":[{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"},{"style":"ITALIC","weight":"500","__typename":"FontStyleData"},{"style":"ITALIC","weight":"700","__typename":"FontStyleData"}],"assetNames":["Poppins-italic-400.woff2","Poppins-italic-500.woff2","Poppins-italic-700.woff2","Poppins-normal-300.woff2","Poppins-normal-400.woff2","Poppins-normal-500.woff2","Poppins-normal-700.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1755250098417","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:pipelines-1755250097533":{"__typename":"CachedAsset","id":"quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:pipelines-1755250097533","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"removeComponents":["community.widget.bannerWidget"],"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"items":[{"layout":"MAIN_SIDE","id":"message-list","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","props":{"lazyLoad":true},"__typename":"QuiltComponent"},{"id":"messages.widget.messageListForNodeByRecentActivityWidget","props":{"viewVariant":{"type":"inline","props":{"useUnreadCount":false,"useViewCount":false,"renderPostTimeBeforeAuthor":true,"useSearchSnippet":false,"useAuthorLogin":true,"clampBodyLines":3,"useAvatar":true,"useBoardIcon":false,"useAuthorRank":false,"useKudosCount":false,"useMedia":false,"usePreviewMedia":false,"useTags":false,"useNode":false,"useNodeLink":true,"useTextBody":true,"truncateBodyLength":-1,"useBody":false,"useRepliesCount":false,"useSolvedBadge":true,"useTimeToRead":false,"timeStampType":"conversation.lastPostingActivityTime","useMessageTimeLink":true,"clampSubjectLines":1,"useSpoilerFreeBody":true,"useNodeHoverCard":true,"avatarSize":"40","boardIconSize":"24","subjectAs":"h6"}},"pagerVariant":{"type":"loadMore"},"panelType":"divider","pageSize":5,"useTitle":true,"sorts":{"conversationLastPostingActivityTime":{"direction":"DESC"}},"hideIfEmpty":true,"style":"compact","showTabs":false},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"},"__typename":"MainSideQuiltSection"}],"__typename":"QuiltContainer"},"__typename":"Quilt"},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1755250098417","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1755250098417","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1755250098417","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:quiltWrapper:snaplogic.prod:Common:1755250097975":{"__typename":"CachedAsset","id":"quiltWrapper:snaplogic.prod:Common:1755250097975","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":false,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"migrated-link-2","params":{"boardId":"ai_ml","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"boardId":"app_integration","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-4","params":{"boardId":"data_integration","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-5","params":{"boardId":"apim","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"releases","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-8","params":{"boardId":"pipelines","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-9","params":{"boardId":"snaps","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-10","params":{"boardId":"snap_dev","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-11","params":{"boardId":"patterns","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-12","params":{"boardId":"snaplabs","categoryId":"products"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-13","params":{"boardId":"sl-tech-blog","categoryId":"products"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-14","params":{"boardId":"solutions","categoryId":"products"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-15","params":{"boardId":"ux_program","categoryId":"products"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-0","params":{"categoryId":"products"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-17","params":{"boardId":"getting_started","categoryId":"learning"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-18","params":{"boardId":"training","categoryId":"learning"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-16","params":{"categoryId":"learning"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-20","params":{"boardId":"sigma","categoryId":"architecture_center"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-21","params":{"boardId":"sigma_podcasts","categoryId":"architecture_center"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-19","params":{"categoryId":"architecture_center"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-22","params":{"categoryId":"sl-events"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-24","params":{"groupHubId":"partners"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"migrated-link-25","params":{"groupHubId":"higher_ed_users"},"routeName":"GroupHubPage"}],"linkType":"INTERNAL","id":"migrated-link-23","params":{"categoryId":"user-groups"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-27","params":{"boardId":"about","categoryId":"community_hub"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-28","params":{"boardId":"about-this-community","categoryId":"nation-hub"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-29","params":{"categoryId":"mvp"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-30","params":{"categoryId":"customer_awards"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-31","params":{"boardId":"hiring","categoryId":"community_hub"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-26","params":{"categoryId":"community_hub"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"0","linkFontWeight":"500","controllerHighlightColor":"#FF0083","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"16px","linkBoxShadowHover":"none","backgroundOpacity":1,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"48px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"0","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"var(--lia-bs-primary)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerHighlightTextColor":"var(--lia-yiq-dark)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-primary)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-primary)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"15px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-primary)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-primary)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-body-color)","visualEffects":{"showBottomBorder":false},"linkTextColor":"var(--lia-bs-primary)"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"assetName":"community-widget-bannerWidget-1744318647965.png","backgroundSize":"COVER","lastModified":"1744318648000,1744318648000","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-white)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"custom.widget.CustomFooterSnaplogic","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":true,"backgroundColor":"#003399","useBackground":false,"backgroundOpacity":1,"title":""},"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":true,"backgroundColor":"#182852","useBackground":false,"backgroundOpacity":1,"title":""},"__typename":"QuiltComponent"},{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:component:custom.widget.CustomFooterSnaplogic-en-us-1755250107453":{"__typename":"CachedAsset","id":"component:custom.widget.CustomFooterSnaplogic-en-us-1755250107453","value":{"component":{"id":"custom.widget.CustomFooterSnaplogic","template":{"id":"CustomFooterSnaplogic","markupLanguage":"REACT","style":null,"texts":{},"defaults":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.CustomFooterSnaplogic","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer_Snaplogic_Subfooter-en-us-1755250107453":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Snaplogic_Subfooter-en-us-1755250107453","value":{"component":{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","template":{"id":"Custom_Footer_Snaplogic_Subfooter","markupLanguage":"HANDLEBARS","style":".custom-footer-bottom {\n --footer-bg-color-darker: #182852;\n --footer-link-color: #ffffff;\n --footer-fg-jade: #2da493;\n\n background-color: var(--footer-bg-color-darker);\n color: var(--footer-link-color);\n padding: 40px 0 32px;\n display: flex;\n flex-direction: column-reverse;\n\n @media (min-width: 991px) {\n flex-direction: row;\n justify-content: space-between;\n }\n\n ul,\n p {\n margin: 0;\n padding: 0;\n list-style: none;\n }\n\n a.link {\n color: var(--footer-link-color);\n font-weight: bold;\n text-decoration: underline;\n\n &:hover {\n color: var(--footer-fg-jade);\n text-decoration: none;\n }\n }\n}\n\n.footer-copyright,\n.social-media-icons {\n width: 100%;\n text-align: center;\n\n @media (min-width: 991px) {\n width: auto;\n text-align: left;\n }\n}\n\n.footer-copyright {\n display: block;\n margin-top: 20px;\n\n @media (min-width: 781px) {\n display: flex;\n justify-content: center;\n gap: 0 20px;\n flex-grow: 1;\n flex-wrap: wrap;\n }\n\n @media (min-width: 991px) {\n margin-top: 0;\n justify-content: flex-start;\n }\n\n ul {\n li {\n display: inline-block;\n }\n\n li + li {\n margin-left: 20px;\n }\n }\n}\n\n.social-media-icons {\n ul.list-inline {\n display: flex;\n align-items: center;\n justify-content: center;\n margin-bottom: 0;\n\n @media (min-width: 781px) {\n align-items: flex-end;\n }\n\n li {\n padding-right: 0;\n\n a {\n padding: 10px;\n\n svg {\n width: 26px;\n height: 26px;\n fill: var(--footer-link-color);\n transition: fill 0.1s ease-in-out;\n }\n }\n\n a:hover {\n svg {\n fill: var(--footer-fg-jade);\n }\n }\n }\n }\n}\n","texts":{},"defaults":{"config":{"applicablePages":[],"description":"Custom footer for links and social media","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"Custom footer for links and social media","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_Custom_Footer_Snaplogic_Subfooter_custom-footer-bottom_1nmjj_1 {\n --footer-bg-color-darker: #182852;\n --footer-link-color: #ffffff;\n --footer-fg-jade: #2da493;\n\n background-color: var(--footer-bg-color-darker);\n color: var(--footer-link-color);\n padding: 2.5rem 0 2rem;\n display: flex;\n flex-direction: column-reverse;\n\n @media (min-width: 991px) {\n flex-direction: row;\n justify-content: space-between;\n }\n\n ul,\n p {\n margin: 0;\n padding: 0;\n list-style: none;\n }\n\n a.custom_widget_Custom_Footer_Snaplogic_Subfooter_link_1nmjj_24 {\n color: var(--footer-link-color);\n font-weight: bold;\n text-decoration: underline;\n\n &:hover {\n color: var(--footer-fg-jade);\n text-decoration: none;\n }\n }\n}\n\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_footer-copyright_1nmjj_36,\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_social-media-icons_1nmjj_37 {\n width: 100%;\n text-align: center;\n\n @media (min-width: 991px) {\n width: auto;\n text-align: left;\n }\n}\n\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_footer-copyright_1nmjj_36 {\n display: block;\n margin-top: 1.25rem;\n\n @media (min-width: 781px) {\n display: flex;\n justify-content: center;\n gap: 0 1.25rem;\n flex-grow: 1;\n flex-wrap: wrap;\n }\n\n @media (min-width: 991px) {\n margin-top: 0;\n justify-content: flex-start;\n }\n\n ul {\n li {\n display: inline-block;\n }\n\n li + li {\n margin-left: 1.25rem;\n }\n }\n}\n\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_social-media-icons_1nmjj_37 {\n ul.custom_widget_Custom_Footer_Snaplogic_Subfooter_list-inline_1nmjj_76 {\n display: flex;\n align-items: center;\n justify-content: center;\n margin-bottom: 0;\n\n @media (min-width: 781px) {\n align-items: flex-end;\n }\n\n li {\n padding-right: 0;\n\n a {\n padding: 0.625rem;\n\n svg {\n width: 1.625rem;\n height: 1.625rem;\n fill: var(--footer-link-color);\n transition: fill 0.1s ease-in-out;\n }\n }\n\n a:hover {\n svg {\n fill: var(--footer-fg-jade);\n }\n }\n }\n }\n}\n","tokens":{"custom-footer-bottom":"custom_widget_Custom_Footer_Snaplogic_Subfooter_custom-footer-bottom_1nmjj_1","link":"custom_widget_Custom_Footer_Snaplogic_Subfooter_link_1nmjj_24","footer-copyright":"custom_widget_Custom_Footer_Snaplogic_Subfooter_footer-copyright_1nmjj_36","social-media-icons":"custom_widget_Custom_Footer_Snaplogic_Subfooter_social-media-icons_1nmjj_37","list-inline":"custom_widget_Custom_Footer_Snaplogic_Subfooter_list-inline_1nmjj_76"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1755250098417","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1755250098417","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1755250098417","value":{"title@userScope:other":"Recent Content","title@userScope:self":"Contributions","title@board:FORUM@userScope:other":"Recent Discussions","title@board:BLOG@userScope:other":"Recent Blogs","emptyDescription":"No content to show","MessageListForNodeByRecentActivityWidgetEditor.nodeScope.label":"Scope","title@instance:1737670726207":"Community Activity"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1755250098417","value":{"homeLink":"Community Home","topOfPage":"Top of Page","buildHash":"Build Hash:","buildNumber":"Build Number:","buildTime":"Build Time:","privacyPolicy":"Privacy Policy","helpLink":"Help"},"localOverride":false},"Forum:board:app_integration":{"__typename":"Forum","id":"board:app_integration","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:data_integration":{"__typename":"Forum","id":"board:data_integration","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:apim":{"__typename":"Forum","id":"board:apim","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:ai_ml":{"__typename":"Forum","id":"board:ai_ml","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:releases":{"__typename":"Forum","id":"board:releases","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:snaps":{"__typename":"Forum","id":"board:snaps","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:patterns":{"__typename":"Forum","id":"board:patterns","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:solutions":{"__typename":"Forum","id":"board:solutions","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:learning":{"__typename":"Category","id":"category:learning","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:getting_started":{"__typename":"Forum","id":"board:getting_started","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:sl-events":{"__typename":"Category","id":"category:sl-events","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:mvp":{"__typename":"Category","id":"category:mvp","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:customer_awards":{"__typename":"Category","id":"category:customer_awards","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:partners":{"__typename":"GroupHub","id":"grouphub:partners","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:higher_ed_users":{"__typename":"GroupHub","id":"grouphub:higher_ed_users","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:community_hub":{"__typename":"Category","id":"category:community_hub","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:about":{"__typename":"Blog","id":"board:about","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:user-groups":{"__typename":"Category","id":"category:user-groups","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:hiring":{"__typename":"Forum","id":"board:hiring","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:training":{"__typename":"Forum","id":"board:training","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:ux_program":{"__typename":"Forum","id":"board:ux_program","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:snap_dev":{"__typename":"Forum","id":"board:snap_dev","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:architecture_center":{"__typename":"Category","id":"category:architecture_center","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:sigma":{"__typename":"Forum","id":"board:sigma","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:sl-tech-blog":{"__typename":"Blog","id":"board:sl-tech-blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:snaplabs":{"__typename":"Forum","id":"board:snaplabs","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Conversation:conversation:40398":{"__typename":"Conversation","id":"conversation:40398","topic":{"__typename":"ForumTopicMessage","uid":40398},"lastPostingActivityTime":"2025-08-22T08:34:13.602-07:00","solved":false},"ForumTopicMessage:message:40398":{"__typename":"ForumTopicMessage","subject":"401 error with HTTP Client and NTLM","conversation":{"__ref":"Conversation:conversation:40398"},"id":"message:40398","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40398","revisionNum":1,"uid":40398,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":8057,"login":"rmaron","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-7.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":2},"postTime":"2025-08-22T08:34:13.602-07:00","lastPublishTime":"2025-08-22T08:34:13.602-07:00","readOnly":false},"Conversation:conversation:40388":{"__typename":"Conversation","id":"conversation:40388","topic":{"__typename":"ForumTopicMessage","uid":40388},"lastPostingActivityTime":"2025-08-11T11:30:02.503-07:00","solved":false},"ForumTopicMessage:message:40388":{"__typename":"ForumTopicMessage","subject":"Pagination and nextCursor in header","conversation":{"__ref":"Conversation:conversation:40388"},"id":"message:40388","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40388","revisionNum":1,"uid":40388,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5263,"login":"jfpelletier","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-2.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":37},"postTime":"2025-07-29T14:13:40.344-07:00","lastPublishTime":"2025-07-29T14:13:40.344-07:00","readOnly":false},"Conversation:conversation:40381":{"__typename":"Conversation","id":"conversation:40381","topic":{"__typename":"ForumTopicMessage","uid":40381},"lastPostingActivityTime":"2025-07-17T14:46:28.452-07:00","solved":true},"ForumTopicMessage:message:40381":{"__typename":"ForumTopicMessage","subject":"Javascript to promote top level lists","conversation":{"__ref":"Conversation:conversation:40381"},"id":"message:40381","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40381","revisionNum":1,"uid":40381,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5714,"login":"Coyote","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-4.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":33},"postTime":"2025-07-17T12:09:05.438-07:00","lastPublishTime":"2025-07-17T12:09:05.438-07:00","readOnly":false},"Conversation:conversation:40369":{"__typename":"Conversation","id":"conversation:40369","topic":{"__typename":"ForumTopicMessage","uid":40369},"lastPostingActivityTime":"2025-06-20T13:57:59.877-07:00","solved":false},"ForumTopicMessage:message:40369":{"__typename":"ForumTopicMessage","subject":"Google Sheets Subscribe questions","conversation":{"__ref":"Conversation:conversation:40369"},"id":"message:40369","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40369","revisionNum":1,"uid":40369,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5263,"login":"jfpelletier","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-2.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":95},"postTime":"2025-06-20T13:57:59.877-07:00","lastPublishTime":"2025-06-20T13:57:59.877-07:00","readOnly":false},"Conversation:conversation:16868":{"__typename":"Conversation","id":"conversation:16868","topic":{"__typename":"ForumTopicMessage","uid":16868},"lastPostingActivityTime":"2025-06-04T05:57:52.226-07:00","solved":true},"ForumTopicMessage:message:16868":{"__typename":"ForumTopicMessage","subject":"Basic string transformations not working","conversation":{"__ref":"Conversation:conversation:16868"},"id":"message:16868","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:16868","revisionNum":1,"uid":16868,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":2269,"login":"darshthakkar","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/images/dS0yMjY5LTY0MDBpQTdBMUQ0MURDRUUzNUZDNw"}},"metrics":{"__typename":"MessageMetrics","views":3350},"postTime":"2023-05-18T10:58:12.261-07:00","lastPublishTime":"2023-05-18T10:58:12.261-07:00","readOnly":false},"QueryVariables:TopicReplyList:message:6472:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:6472:1","value":{"id":"message:6472","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":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1755250098417","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"Snaps","migrated-link-7":"Release Notes and Announcements","migrated-link-8":"Designing and Running Pipelines","Common-sigma-framework-link":"Sigma Framework","migrated-link-1":"Product Category Discussions","Common-data_integration-link":"Data Integration","migrated-link-2":"AI/ML & GenAI App Builder","migrated-link-0":"Discussions","migrated-link-5":"API Management","migrated-link-6":"Getting the Most Out of the SnapLogic Platform","migrated-link-3":"App Integration","Common-learning-link":"Learning","migrated-link-4":"Data Integration","Common-ai_ml-link":"AI/ML & GenAI App Builder","Common-partner-group-link":"Partner Group","Common-customer_awards-link":"Customer Awards","Common-discussions-link":"Discussions","Common-snap-labs-link":"Snap Labs","Common-app-integration-link":"Product Category Discussions","Common-hiring-link":"Who's Hiring","Common-enterprise-alchemists-link":"Enterprise Alchemists","Common-higher-ed-user-groupsforum-board-link":"Higher Ed Users Group","Common-snaps-link":"Snaps","Common-snap_dev-link":"Snap Development","Common-partner-user-groupsforum-board-link":"Partner User Group","migrated-link-30":"Customer Awards","migrated-link-31":"Who's Hiring","Common-mvp-link":"MVP Program","Common-solution-for-your-business-link":"Solutions for Your Business","Common-platform-link":"Getting the Most Out of the SnapLogic Platform","migrated-link-29":"MVP Program","Common-sigma-framework-library-link":"Sigma Framework Library","migrated-link-27":"About the Nation","Common-pipelines-link":"Designing and Running Pipelines","migrated-link-28":"About this Community","migrated-link-25":"Higher Ed Users Group","migrated-link-26":"Nation Hub","Common-patterns-link":"Patterns","migrated-link-23":"User Groups","Common-partner-category-link":"Partner Category","migrated-link-24":"Partner User Group","Common-product-category-discussions-link":"Product Category Discussions","Common-get-started-link":"Getting Started","Common-about-the-nation-link":"About the Nation","Common-sl-events-link":"All Events","Common-about-this-community-link":"About this Community","Common-nation-hub-link":"Nation Hub","migrated-link-21":"Enterprise Alchemists","migrated-link-22":"All Events","migrated-link-20":"Sigma Framework Library","migrated-link-18":"SnapLogic Academy","migrated-link-19":"Sigma Framework","migrated-link-16":"Learning","migrated-link-17":"Getting Started","migrated-link-14":"Solutions for Your Business","migrated-link-15":"User Experience Program","migrated-link-12":"SnapLabs","migrated-link-13":"SnapLogic Technical Blog","Common-ux_program-link":"User Experience Program","Common-snaplabsforum-board-link":"SnapLabs","migrated-link-10":"Snap Development","migrated-link-11":"Patterns","Common-snaplogic-technical-blog-link":"SnapLogic Technical Blog","Common-releases-link":"Release Notes and Announcements","Common-app_integration-link":"App Integration","Common-snap-logic-academy-link":"SnapLogic Academy","Common-apim-link":"API Management","Common-user-groups-link":"User Groups"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1755250098417","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1755250098417","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1755250098417","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1755250098417","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1755250098417","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1755250098417","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1755250098417","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solution","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1755250098417","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},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1755250098417","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1755250098417","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1755250098417","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1755250098417","value":{"alt":"Powered By Khoros"},"localOverride":false},"Rank:rank:4":{"__typename":"Rank","id":"rank:4","position":3,"name":"Employee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:769":{"__typename":"User","id":"user:769","uid":769,"login":"ptaylor","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2018-09-11T09:43:15.303-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:4"},"entityType":"USER","eventPath":"community:iaudz84835/user:769"},"ModerationData:moderation_data:6481":{"__typename":"ModerationData","id":"moderation_data:6481","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:6481":{"__typename":"AcceptedSolutionMessage","uid":6481,"id":"message:6481","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6481","revisionNum":1,"author":{"__ref":"User:user:769"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:6472"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6481"},"body":"@acesario I think what I’m understanding is that one of your files might have an array with more than one element, but the default parsing turns each element into a separate output document. You can change that by setting “Process array” to false on the JSON Parser. That will produce a single output document whose data is the full array. Before you can feed that into the Join, you’ll have to use a Mapper to map the array to the field of an object. I’ve attached a sample pipeline.
\nCommunity 8107_2020_08_27.slp (9.8 KB)
\nHere are the inputs…
\nfileA.json:
\n[\n {\n \"file\": \"A\"\n }\n]\n
\nfileB.json:
\n[\n {\n \"file\": \"B\",\n \"id\": 1\n },\n {\n \"file\": \"B\",\n \"id\": 2\n }\n]\n
\nOutput of the Join:
\n[\n {\n \"fileA\": {\n \"file\": \"A\"\n },\n \"fileB\": [\n {\n \"file\": \"B\",\n \"id\": 1\n },\n {\n \"file\": \"B\",\n \"id\": 2\n }\n ]\n }\n]\n
\nThat combines all of the data from both input files into a single document. You can modify the Mappers to move things to the right places.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":1,"postTime":"2020-08-27T14:27:00.155-07:00","lastPublishTime":"2020-08-27T14:27:00.155-07:00","solution":true,"metrics":{"__typename":"MessageMetrics","views":10156},"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":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:6482"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[{"__typename":"AttachmentEdge","node":{"__ref":"Attachment:{\"id\":\"attachment:message6481AttachmentNumber1\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/653/1/Community%208107_2020_08_27.slp\"}"}}],"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:6482":{"__typename":"ModerationData","id":"moderation_data:6482","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6482":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1229"},"id":"message:6482","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6482","revisionNum":1,"uid":6482,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"AcceptedSolutionMessage:message:6481"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6482"},"body":"@ptaylor Thank you for the sample pipelien and for the info on “Process array”… that is very helpful.
\nI very much appreciate your patience and persistence as I learn this.
What if I were to transform the first input file based on name?
\nTransform: Instance”:“Transaction Name\" to Instance”:“TRANSACTION\" so that
\nInput0
\n“Instance”:“TRANSACTION”
\n“ID”:“bae77”
Input1
\n“TRANSACTION”:“AC00014623”
Still, trying to use input0 as a a mapping in this case.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2020-08-20T03:40:58.256-07:00","lastPublishTime":"2020-08-20T03:40:58.256-07:00","metrics":{"__typename":"MessageMetrics","views":4813},"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:6474":{"__typename":"ModerationData","id":"moderation_data:6474","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6474":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:769"},"id":"message:6474","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6474","revisionNum":1,"uid":6474,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:6472"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6474"},"body":"Try a Join snap with a “1 = 1” join path as shown here:
\nFollowed by a Mapper:
\n@ptaylor Thanks for the response. This seems to work fine for one row, but not for multiples, especially since I have some unmatched.
\nCan I ask a few questions on use of a join?
\nIf I want to combine 2 documents (one with values, one with IDs) into one as follows:
\nDesired Output:
\n[
\n{
\n“TRANSACTION”: “AC00014623”,
\n“FIRST_NAME”: “Jorge”,
\n“LAST_NAME”: “HereorThere”,
\n“TRANSACTION_WID”: “bae771d54a9d018123ac687fea12800c”,
\n“FIRST_NAME_WID”: “bae771d54a9d01f0a3b4687fea12810c”,
\n“LAST_NAME_WID”: “bae771d54a9d011c59ba687fea12820c”
\n}
\n]
or, in the case of multiples, using the same WIDS:
\n[
\n{
\n“TRANSACTION”: “AC00014649”,
\n“FIRST_NAME”: “Sarah”,
\n“LAST_NAME”: “Whereever”,
\n“TRANSACTION_WID”: “bae771d54a9d018123ac687fea12800c”,
\n“FIRST_NAME_WID”: “bae771d54a9d01f0a3b4687fea12810c”,
\n“LAST_NAME_WID”: “bae771d54a9d011c59ba687fea12820c”
\n},
\n{
\n“TRANSACTION”: “AC00014649”,
\n“FIRST_NAME”: “Collette”,
\n“LAST_NAME”: “PorterBeer”,
\n“TRANSACTION_WID”: “bae771d54a9d018123ac687fea12800c”,
\n“FIRST_NAME_WID”: “bae771d54a9d01f0a3b4687fea12810c”,
\n“LAST_NAME_WID”: “bae771d54a9d011c59ba687fea12820c”
\n}
\n]
I have uploaded my slp file with what I have so far.Sub - WID Joiner Test_2020_08_25.slp (24.4 KB)
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2020-08-25T10:47:55.136-07:00","lastPublishTime":"2020-08-25T10:47:55.136-07:00","metrics":{"__typename":"MessageMetrics","views":4812},"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:6476"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[{"__typename":"AttachmentEdge","cursor":"MjUuNHwyLjF8b3w1fF9OVl98MQ","node":{"__ref":"Attachment:{\"id\":\"attachment:message6475AttachmentNumber1\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/647/1/Sub%20-%20WID%20Joiner%20Test_2020_08_25.slp\"}"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:6476":{"__typename":"ModerationData","id":"moderation_data:6476","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6476":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:769"},"id":"message:6476","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6476","revisionNum":1,"uid":6476,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:6475"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6476"},"body":"I’m really unclear on what your use case is. You said what the Desired Output is, but what’s the input?
\nAlso, please read the documentation for the Join snap if you haven’t yet.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"181","kudosSumWeight":0,"repliesCount":0,"postTime":"2020-08-26T12:12:08.950-07:00","lastPublishTime":"2020-08-26T12:12:08.950-07:00","metrics":{"__typename":"MessageMetrics","views":4813},"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":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:6477":{"__typename":"ModerationData","id":"moderation_data:6477","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6477":{"__typename":"ForumReplyMessage","uid":6477,"id":"message:6477","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6477","revisionNum":1,"author":{"__ref":"User:user:1229"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:6472"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6477"},"body":"@ptaylor Apologies that I only put the input files in the attachment. Here they are for your reference:
\nInput file 1
\n[{“TRANSACTION”: “AC00014623”,
\n“FIRST_NAME”: “Jorge”,
\n“LAST_NAME”: “Whoever”}]
Input file 2:
\n[{“TRANSACTION_WID”: “bae771d54a9d018123ac687fea12800c”,
\n“FIRST_NAME_WID”: “bae771d54a9d01f0a3b4687fea12810c”,
\n“LAST_NAME_WID”: “bae771d54a9d011c59ba687fea12820c”
\n}]
The use case at this point is basically an APPEND the WID values to each input1 document. File 2 does not change. File 1 may have many rows.
\nNote: I was able to accomplish this via hard coding the values to variables in a mapper, but the reference id’s may change from time to time, and it is better practice to pull from a file, or web service call. I hope this helps explain what I’m trying to accomplish.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2020-08-26T15:40:09.600-07:00","lastPublishTime":"2020-08-26T15:40:09.600-07:00","metrics":{"__typename":"MessageMetrics","views":3868},"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:6478"}}]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:6478":{"__typename":"ModerationData","id":"moderation_data:6478","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6478":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:769"},"id":"message:6478","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6478","revisionNum":1,"uid":6478,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:6477"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6478"},"body":"Sorry, I’m still not following. There are no values in common between the two files, so how would you expect a join to work?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"127","kudosSumWeight":0,"repliesCount":0,"postTime":"2020-08-27T11:09:30.367-07:00","lastPublishTime":"2020-08-27T11:09:30.367-07:00","metrics":{"__typename":"MessageMetrics","views":3867},"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":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:6479":{"__typename":"ModerationData","id":"moderation_data:6479","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6479":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1229"},"id":"message:6479","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6479","revisionNum":1,"uid":6479,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:6472"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6479"},"body":"@ptaylor Correct. There are currently no matched fields. In other tools, I have been able to append one file with another.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"127","kudosSumWeight":0,"repliesCount":0,"postTime":"2020-08-27T11:32:17.509-07:00","lastPublishTime":"2020-08-27T11:32:17.509-07:00","metrics":{"__typename":"MessageMetrics","views":3867},"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":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"User:user:168":{"__typename":"User","id":"user:168","uid":168,"login":"koryknick","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2017-05-18T07:22:45.905-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-1.svg?time=0"},"rank":{"__ref":"Rank:rank:4"},"entityType":"USER","eventPath":"community:iaudz84835/user:168"},"ModerationData:moderation_data:6480":{"__typename":"ModerationData","id":"moderation_data:6480","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:6480":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:168"},"id":"message:6480","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:6472/message:6480","revisionNum":1,"uid":6480,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:6472"},"conversation":{"__ref":"Conversation:conversation:6472"},"subject":"Re: How to best combine/map values from separate inputs?","moderationData":{"__ref":"ModerationData:moderation_data:6480"},"body":"@acesario - From what you are describing, I think @pataylor provided the correct solution with the Join snap using a 1=1 condition. Assuming that file 1 has an arbitrary number of records, and file 2 has only 1 record, it would successfully append the fields in file 2 for each record in file 1. This would match what you did with the hardcoded values in the Mapper that you describe earlier.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2020-08-27T12:05:47.339-07:00","lastPublishTime":"2020-08-27T12:05:47.339-07:00","metrics":{"__typename":"MessageMetrics","views":3870},"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:6472"},"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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1755250098417","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1755250098417","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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1755250098417","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1755250098417","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1755250098417","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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1755250098417","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1755250098417","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1755250098417","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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1755250098417","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1755250098417","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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1755250098417","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListMenu-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListMenu-1755250098417","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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1755250098417","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-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1755250098417","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1755250098417","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"Attachment:{\"id\":\"attachment:message6481AttachmentNumber1\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/653/1/Community%208107_2020_08_27.slp\"}":{"__typename":"Attachment","id":"attachment:message6481AttachmentNumber1","filename":"Community 8107_2020_08_27.slp","filesize":10079,"contentType":"application/octet-stream","url":"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/653/1/Community%208107_2020_08_27.slp"},"Attachment:{\"id\":\"attachment:message6475AttachmentNumber1\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/647/1/Sub%20-%20WID%20Joiner%20Test_2020_08_25.slp\"}":{"__typename":"Attachment","id":"attachment:message6475AttachmentNumber1","filename":"Sub - WID Joiner Test_2020_08_25.slp","filesize":24968,"contentType":"application/octet-stream","url":"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/647/1/Sub%20-%20WID%20Joiner%20Test_2020_08_25.slp"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1755250098417","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1755250098417","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/common/ExternalLinkWarningModal-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/common/ExternalLinkWarningModal-1755250098417","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/tags/TagView/TagViewChip-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1755250098417","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1755250098417":{"__typename":"CachedAsset","id":"text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1755250098417","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}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"pipelines","messageSubject":"how-to-best-combinemap-values-from-separate-inputs","messageId":"6472"},"buildId":"tzrZqX6Puz2ajpVr66RMN","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","shared_client_components_common_List_UnwrappedList","components_tags_TagView","components_tags_TagView_TagViewChip","components_attachments_AttachmentView","components_attachments_AttachmentView_AttachmentViewChip"],"appGip":true,"scriptLoader":[]}