\n{codeArr:[xyz, abc, def], codeStr:xyz,abc,def}
\n“codeArr”: [xyz, abc, def]
\n“xyz”,
\n“abc”,
\n“def”
\n“codeStr”: “xyz,abc,def”
\n{codeArr:[rew, wbc, wwe], codeStr:rew,wbc,wwe}
\n“codeArr”: [rew, wbc, wwe]
\n“rew”,
\n“wbc”,
\n“wwe”
“codeStr”: “rew,wbc,wwe”
\n\nIs this what you were expecting? of course if you want a single value from the code, you would need to define the criteria.
\nYou can further do all variations
\nPS: It would be nice if you pasted your entire RAW json. I had to plugin the \"\" around all json elements and jsonify it to get the exact format.
Thank you for your response, and sorry for the inconvenience with JSON. My requirement is little different. Given the original JSON source, I have to do a lookup on a second JSON source and add the exp_time property to the case step
\n[
\n{
\n“code”: “abc”,
\n“exp_time”: “30s”
\n},
\n{
\n“code”: “xyz”,
\n“exp_time”: “20s”
\n},
\n{
\n“code”: “def”,
\n“exp_time”: “40s”
\n}
\n]
The output we are expecting is something like
\n[
\n{
\n“caseId”: 1,
\n“caseDate”: “2017-08-04”,
\n“caseSteps”: [{
\n“code”: “xyz”,
\n“value”: 10,
\n“primary”: null,
\n“exp_time”: “20s”
\n},
\n{
\n“code”: “abc”,
\n“value”: 20,
\n“primary”: null,
\n“exp_time”: “30s”
\n},
\n{
\n“code”: “def”,
\n“value”: 20,
\n“primary”: null,
\n“exp_time”: “40s”
\n}]
\n}
\n]
please post the second json source and mention the condition you want to join.
\nYou can add exp_time to caseSteps in the mapper snap.
\nThat was just a sample to manipulate JSON but you can achieve more granularity.
","board":{"__ref":"Forum:board:pipelines"},"conversation":{"__ref":"Conversation:conversation:22341"},"author":{"__typename":"User","login":"nganapathiraju"},"postTime":"2017-08-04T08:12:39.154-07:00","kudosSumWeight":0}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3w1fDE0OjAsMzk6MXw0","node":{"__typename":"ForumReplyMessage","uid":22345,"body":"Thanks Again, the second json source is given in the post. I have it here again. The join is on the “code” from “casestep” to the “code” in this source. exp_time from second source has to be copied over the main document
\n[
\n{
\n“code”: “abc”,
\n“exp_time”: “30s”
\n},
\n{
\n“code”: “xyz”,
\n“exp_time”: “20s”
\n},
\n{
\n“code”: “def”,
\n“exp_time”: “40s”
\n}
\n]
I hope this is what you want.
\nBut without complete requirement and data, I cannot get you complete solution.
\nDefinitely this should be a way forward for you.
\nHello,
\nI have a incoming JSON document that has cases and array of casesteps inside. I need to do a lookup on the case step code from a table in the database and add additional properties to the casestep. Is there a way to accomplish this? We tried doing SQL Lookup or In Memory lookup but joining with each case step on the code didn’t work. The jsonPath syntax we were using always returned an array of codes and the lookup was failing. Any help is appreciated!
\n[
\n{
\ncaseId: 1,
\ncaseDate: “2017-08-04”,
\ncaseSteps: [{
\ncode: “xyz”,
\nvalue: 10,
\nprimary: null
\n},
\n{
\ncode: “abc”,
\nvalue: 20,
\nprimary: null
\n},
\n{
\ncode: “def”,
\nvalue: 20,
\nprimary: null
\n}]
\n},
\n{
\ncaseId: 2,
\ncaseDate: “2017-08-04”,
\ncaseSteps: [{
\ncode: “rew”,
\nvalue: 10,
\nprimary: null
\n},
\n{
\ncode: “wbc”,
\nvalue: 20,
\nprimary: null
\n},
\n{
\ncode: “wwe”,
\nvalue: 20,
\nprimary: null
\n}]
\n}
\n]
Thanks
","body@stringLength":"1097","rawBody":"Hello,
\nI have a incoming JSON document that has cases and array of casesteps inside. I need to do a lookup on the case step code from a table in the database and add additional properties to the casestep. Is there a way to accomplish this? We tried doing SQL Lookup or In Memory lookup but joining with each case step on the code didn’t work. The jsonPath syntax we were using always returned an array of codes and the lookup was failing. Any help is appreciated!
\n[
\n{
\ncaseId: 1,
\ncaseDate: “2017-08-04”,
\ncaseSteps: [{
\ncode: “xyz”,
\nvalue: 10,
\nprimary: null
\n},
\n{
\ncode: “abc”,
\nvalue: 20,
\nprimary: null
\n},
\n{
\ncode: “def”,
\nvalue: 20,
\nprimary: null
\n}]
\n},
\n{
\ncaseId: 2,
\ncaseDate: “2017-08-04”,
\ncaseSteps: [{
\ncode: “rew”,
\nvalue: 10,
\nprimary: null
\n},
\n{
\ncode: “wbc”,
\nvalue: 20,
\nprimary: null
\n},
\n{
\ncode: “wwe”,
\nvalue: 20,
\nprimary: null
\n}]
\n}
\n]
Thanks
","kudosSumWeight":0,"postTime":"2017-08-04T05:57:45.308-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":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:22341_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":8269},"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":"Hello, \n I have a incoming JSON document that has cases and array of casesteps inside. I need to do a lookup on the case step code from a table in the database and add additional properties to the ca...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:22342"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mg","node":{"__ref":"ForumReplyMessage:message:22343"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mw","node":{"__ref":"ForumReplyMessage:message:22345"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:22341":{"__typename":"Conversation","id":"conversation:22341","solved":false,"topic":{"__ref":"ForumTopicMessage:message:22341"},"lastPostingActivityTime":"2017-08-04T17:32:35.520-07:00","lastPostTime":"2017-08-04T17:32:35.520-07:00","unreadReplyCount":10,"isSubscribed":false},"ModerationData:moderation_data:22341":{"__typename":"ModerationData","id":"moderation_data:22341","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:22341_1":{"__typename":"Revision","id":"revision:22341_1","lastEditTime":"2017-08-04T05:57:45.308-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: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: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: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: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":34},"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":31},"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":3349},"postTime":"2023-05-18T10:58:12.261-07:00","lastPublishTime":"2023-05-18T10:58:12.261-07:00","readOnly":false},"Conversation:conversation:40044":{"__typename":"Conversation","id":"conversation:40044","topic":{"__typename":"ForumTopicMessage","uid":40044},"lastPostingActivityTime":"2025-06-04T05:49:25.845-07:00","solved":true},"ForumTopicMessage:message:40044":{"__typename":"ForumTopicMessage","subject":"Can we generate XML file in pretty print format using native snapLogic snaps?","conversation":{"__ref":"Conversation:conversation:40044"},"id":"message:40044","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40044","revisionNum":1,"uid":40044,"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":673},"postTime":"2025-04-14T09:19:56.464-07:00","lastPublishTime":"2025-04-14T09:19:56.464-07:00","readOnly":false},"QueryVariables:TopicReplyList:message:22341:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:22341:1","value":{"id":"message:22341","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:3":{"__typename":"Rank","id":"rank:3","position":2,"name":"Former Employee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:41":{"__typename":"User","id":"user:41","uid":41,"login":"nganapathiraju","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2017-02-10T14:48:27.208-08: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:3"},"entityType":"USER","eventPath":"community:iaudz84835/user:41"},"ModerationData:moderation_data:22342":{"__typename":"ModerationData","id":"moderation_data:22342","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:22342":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:41"},"id":"message:22342","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:22341/message:22342","revisionNum":1,"uid":22342,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:22341"},"conversation":{"__ref":"Conversation:conversation:22341"},"subject":"Re: Lookup on an array in the input document","moderationData":{"__ref":"ModerationData:moderation_data:22342"},"body":"\n\n[{, …}, {, …}]
\n
\n{codeArr:[xyz, abc, def], codeStr:xyz,abc,def}
\n“codeArr”: [xyz, abc, def]
\n“xyz”,
\n“abc”,
\n“def”
\n“codeStr”: “xyz,abc,def”
\n{codeArr:[rew, wbc, wwe], codeStr:rew,wbc,wwe}
\n“codeArr”: [rew, wbc, wwe]
\n“rew”,
\n“wbc”,
\n“wwe”“codeStr”: “rew,wbc,wwe”
\n
Is this what you were expecting? of course if you want a single value from the code, you would need to define the criteria.
\nYou can further do all variations
\nPS: It would be nice if you pasted your entire RAW json. I had to plugin the \"\" around all json elements and jsonify it to get the exact format.
Thank you for your response, and sorry for the inconvenience with JSON. My requirement is little different. Given the original JSON source, I have to do a lookup on a second JSON source and add the exp_time property to the case step
\n[
\n{
\n“code”: “abc”,
\n“exp_time”: “30s”
\n},
\n{
\n“code”: “xyz”,
\n“exp_time”: “20s”
\n},
\n{
\n“code”: “def”,
\n“exp_time”: “40s”
\n}
\n]
The output we are expecting is something like
\n[
\n{
\n“caseId”: 1,
\n“caseDate”: “2017-08-04”,
\n“caseSteps”: [{
\n“code”: “xyz”,
\n“value”: 10,
\n“primary”: null,
\n“exp_time”: “20s”
\n},
\n{
\n“code”: “abc”,
\n“value”: 20,
\n“primary”: null,
\n“exp_time”: “30s”
\n},
\n{
\n“code”: “def”,
\n“value”: 20,
\n“primary”: null,
\n“exp_time”: “40s”
\n}]
\n}
\n]
please post the second json source and mention the condition you want to join.
\nYou can add exp_time to caseSteps in the mapper snap.
\nThat was just a sample to manipulate JSON but you can achieve more granularity.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2017-08-04T08:12:39.154-07:00","lastPublishTime":"2017-08-04T08:12:39.154-07:00","metrics":{"__typename":"MessageMetrics","views":2836},"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:22345":{"__typename":"ModerationData","id":"moderation_data:22345","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:22345":{"__typename":"ForumReplyMessage","uid":22345,"id":"message:22345","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:22341/message:22345","revisionNum":1,"author":{"__ref":"User:user:349"},"readOnly":false,"repliesCount":6,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:22341"},"conversation":{"__ref":"Conversation:conversation:22341"},"subject":"Re: Lookup on an array in the input document","moderationData":{"__ref":"ModerationData:moderation_data:22345"},"body":"Thanks Again, the second json source is given in the post. I have it here again. The join is on the “code” from “casestep” to the “code” in this source. exp_time from second source has to be copied over the main document
\n[
\n{
\n“code”: “abc”,
\n“exp_time”: “30s”
\n},
\n{
\n“code”: “xyz”,
\n“exp_time”: “20s”
\n},
\n{
\n“code”: “def”,
\n“exp_time”: “40s”
\n}
\n]
I hope this is what you want.
\nBut without complete requirement and data, I cannot get you complete solution.
\nDefinitely this should be a way forward for you.
\nIgnatius_cases_2017_08_04.slp (9.0 KB)
\nAttached is the sample I worked. I am sure you can improve upon.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"107","kudosSumWeight":0,"repliesCount":1,"postTime":"2017-08-04T09:12:27.626-07:00","lastPublishTime":"2017-08-04T09:12:27.626-07:00","metrics":{"__typename":"MessageMetrics","views":2251},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:100":{"__typename":"User","id":"user:100","uid":100,"login":"tstack","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2017-03-29T13:25:59.833-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:3"},"entityType":"USER","eventPath":"community:iaudz84835/user:100"},"ModerationData:moderation_data:22348":{"__typename":"ModerationData","id":"moderation_data:22348","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:22348":{"__typename":"ForumReplyMessage","uid":22348,"id":"message:22348","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:22341/message:22348","revisionNum":1,"author":{"__ref":"User:user:100"},"readOnly":false,"repliesCount":2,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:22345"},"conversation":{"__ref":"Conversation:conversation:22341"},"subject":"Re: Lookup on an array in the input document","moderationData":{"__ref":"ModerationData:moderation_data:22348"},"body":"\nThe Lookup snaps are going to operate on documents and not arrays inside of documents. You could use a JSONSplitter snap to break up the array into multiple documents, but then you probably need to collect them back together to keep the original format, which can be difficult. It might be easier to use the expression language to perform the lookups.
\n\nWould you be able to restructure this source data so that it is more like an object? For example:
\n{\n \"abc\" : {\n \"exp_time\": \"30s\"\n },\n \"xyz\" : {\n \"exp_time\": \"20s\"\n },\n ...\n}
\nIf so, the lookup is then just a matter of getting the property from this object. If this JSON source data is static and in a file, you can import it via an expression library (see https://doc.snaplogic.com/wiki/spaces/SD/pages/1438110/Expression+Libraries).
\nFor example, if you imported this source data as a library with the name ‘source’. You can then use a map() method to perform the transform on the array:
\n$.caseSteps.map(elem => elem.extend(lib.source[elem.code]))
\nThis code will iterate over the the elements of the array using the map() method. For each element, it will execute the function that was passed in to create the new value for the element. The callback function looks up the data to add in to the object (lib.source[elem.code]) and then creates a new object from the existing one and the extra data (elem.extend()).
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2017-08-04T09:32:51.623-07:00","lastPublishTime":"2017-08-04T09:32:51.623-07:00","metrics":{"__typename":"MessageMetrics","views":2251},"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":"MjUuNHwyLjF8b3wxfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:22350"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:22350":{"__typename":"ModerationData","id":"moderation_data:22350","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:22350":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:349"},"id":"message:22350","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:22341/message:22350","revisionNum":1,"uid":22350,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:22348"},"conversation":{"__ref":"Conversation:conversation:22341"},"subject":"Re: Lookup on an array in the input document","moderationData":{"__ref":"ModerationData:moderation_data:22350"},"body":"Thank you we will look into this. Is it possible to load the expression library from database?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"96","kudosSumWeight":0,"repliesCount":1,"postTime":"2017-08-04T12:05:32.914-07:00","lastPublishTime":"2017-08-04T12:05:32.914-07:00","metrics":{"__typename":"MessageMetrics","views":2251},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"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/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},"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}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"pipelines","messageSubject":"lookup-on-an-array-in-the-input-document","messageId":"22341"},"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"],"appGip":true,"scriptLoader":[]}