\n
So, finally you can dynamically filter out the columns from the root object using the following expression in a Mapper Snap:
\n$.filter((v,k) => $.get(_schema).indexOf(k) != -1)\n
\nSample pipeline:
\n–sl-comm-dynamic-columns-parameter_2023_05_12.slp (6.8 KB)
Let me know if this helps you @Tuomas.
\nBR,
\nAleksandar.
Hello!
\nI have REST API source from which I ingest data and load it to BigQuery. I am executing this dynamically with parameters as there are multiple endpoints to query. I am using mapper to define the schema before loading, in this case with the pass-through enabled. However, I have run into a problem, that sometimes the API doesn’t return certain object in the json. Then, when I auto-create the table during load, it may not define this missing column in the schema based on the sample, but then breaks when this column suddenly appears. Due to this being a dynamic pipeline, I cannot hard-code any single columns to the mapper, as the column names are different for each job. Also, the number of columns might differ.
\nSo is there a way to dynamically define the column names I want to keep from the source? For example I a good solution could be one where I can define a single json, array or some other sort of string that contains the namespace of columns I’d like to keep, and just give that as a parameter to the mapper.
\nJust to showcase with an example what I would want out with the dynamic expression:
\nSource 1:
\n[
\n{
\n“a”:“123”,
\n“b”:“qwerty”,
\n“c”:“aaa”,
\n“d”:asd\",
\n“e”:“111”
\n},
\n{
\n“a”:“456”,
\n“b”:“zxcvbn”,
\n“c”:“bbb”,
\n“d”:fgh\",
\n“e”:“222”
\n}
\n]
Target schema 1:
\na, b, c, e
Source 2:
\n{
\n“h”:“123”,
\n“i”:“qwerty”,
\n“j”:“aaa”,
\n“k”:asd\",
\n“l”:“111”
\n},
Target schema 2:
\ni, j, k
Hopefully you get what I’m after 🙂 Thanks
\n-Tuomas
","body@stringLength":"1716","rawBody":"Hello!
\nI have REST API source from which I ingest data and load it to BigQuery. I am executing this dynamically with parameters as there are multiple endpoints to query. I am using mapper to define the schema before loading, in this case with the pass-through enabled. However, I have run into a problem, that sometimes the API doesn’t return certain object in the json. Then, when I auto-create the table during load, it may not define this missing column in the schema based on the sample, but then breaks when this column suddenly appears. Due to this being a dynamic pipeline, I cannot hard-code any single columns to the mapper, as the column names are different for each job. Also, the number of columns might differ.
\nSo is there a way to dynamically define the column names I want to keep from the source? For example I a good solution could be one where I can define a single json, array or some other sort of string that contains the namespace of columns I’d like to keep, and just give that as a parameter to the mapper.
\nJust to showcase with an example what I would want out with the dynamic expression:
\nSource 1:
\n[
\n{
\n“a”:“123”,
\n“b”:“qwerty”,
\n“c”:“aaa”,
\n“d”:asd\",
\n“e”:“111”
\n},
\n{
\n“a”:“456”,
\n“b”:“zxcvbn”,
\n“c”:“bbb”,
\n“d”:fgh\",
\n“e”:“222”
\n}
\n]
Target schema 1:
\na, b, c, e
Source 2:
\n{
\n“h”:“123”,
\n“i”:“qwerty”,
\n“j”:“aaa”,
\n“k”:asd\",
\n“l”:“111”
\n},
Target schema 2:
\ni, j, k
Hopefully you get what I’m after 🙂 Thanks
\n-Tuomas
","kudosSumWeight":0,"postTime":"2023-05-12T06:11:17.781-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuNHwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:dynamic","text":"dynamic","time":"2023-07-25T02:37:18.962-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjUuNHwyLjF8b3wxMHxfTlZffDI","node":{"__typename":"Tag","id":"tag:mapper","text":"mapper","time":"2023-07-25T02:37:05.869-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":2,"currentRevision":{"__ref":"Revision:revision:21456_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":5836},"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 REST API source from which I ingest data and load it to BigQuery. I am executing this dynamically with parameters as there are multiple endpoints to query. I am using mapper to define...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"AcceptedSolutionMessage:message:21457"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mg","node":{"__ref":"ForumReplyMessage:message:21459"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:21456":{"__typename":"Conversation","id":"conversation:21456","solved":true,"topic":{"__ref":"ForumTopicMessage:message:21456"},"lastPostingActivityTime":"2023-05-23T04:55:02.104-07:00","lastPostTime":"2023-05-23T04:55:02.104-07:00","unreadReplyCount":5,"isSubscribed":false},"ModerationData:moderation_data:21456":{"__typename":"ModerationData","id":"moderation_data:21456","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:21456_1":{"__typename":"Revision","id":"revision:21456_1","lastEditTime":"2023-05-12T06:11:17.781-07:00"},"CachedAsset:theme:customTheme1-1750778158756":{"__typename":"CachedAsset","id":"theme:customTheme1-1750778158756","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1750955846246","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:snaps-1752705640954":{"__typename":"CachedAsset","id":"quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:snaps-1752705640954","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1750955846246","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1750955846246","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:quiltWrapper:snaplogic.prod:Common:1750955846177":{"__typename":"CachedAsset","id":"quiltWrapper:snaplogic.prod:Common:1750955846177","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":false,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"migrated-link-2","params":{"boardId":"ai_ml","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"boardId":"app_integration","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-4","params":{"boardId":"data_integration","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-5","params":{"boardId":"apim","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"releases","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-8","params":{"boardId":"pipelines","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-9","params":{"boardId":"snaps","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-10","params":{"boardId":"snap_dev","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-11","params":{"boardId":"patterns","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-12","params":{"boardId":"snaplabs","categoryId":"products"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-13","params":{"boardId":"sl-tech-blog","categoryId":"products"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-14","params":{"boardId":"solutions","categoryId":"products"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-15","params":{"boardId":"ux_program","categoryId":"products"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-0","params":{"categoryId":"products"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-17","params":{"boardId":"getting_started","categoryId":"learning"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-18","params":{"boardId":"training","categoryId":"learning"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-16","params":{"categoryId":"learning"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-20","params":{"boardId":"sigma","categoryId":"architecture_center"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-21","params":{"boardId":"sigma_podcasts","categoryId":"architecture_center"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-19","params":{"categoryId":"architecture_center"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-22","params":{"categoryId":"sl-events"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-24","params":{"groupHubId":"partners"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"migrated-link-25","params":{"groupHubId":"higher_ed_users"},"routeName":"GroupHubPage"}],"linkType":"INTERNAL","id":"migrated-link-23","params":{"categoryId":"user-groups"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-27","params":{"boardId":"about","categoryId":"community_hub"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-28","params":{"boardId":"about-this-community","categoryId":"nation-hub"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-29","params":{"categoryId":"mvp"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-30","params":{"categoryId":"customer_awards"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-31","params":{"boardId":"hiring","categoryId":"community_hub"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-26","params":{"categoryId":"community_hub"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"0","linkFontWeight":"500","controllerHighlightColor":"#FF0083","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"16px","linkBoxShadowHover":"none","backgroundOpacity":1,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"48px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"0","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"var(--lia-bs-primary)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerHighlightTextColor":"var(--lia-yiq-dark)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-primary)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-primary)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"15px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-primary)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-primary)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-body-color)","visualEffects":{"showBottomBorder":false},"linkTextColor":"var(--lia-bs-primary)"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"assetName":"community-widget-bannerWidget-1744318647965.png","backgroundSize":"COVER","lastModified":"1744318648000,1744318648000","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-white)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"custom.widget.CustomFooterSnaplogic","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":true,"backgroundColor":"#003399","useBackground":false,"backgroundOpacity":1,"title":""},"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":true,"backgroundColor":"#182852","useBackground":false,"backgroundOpacity":1,"title":""},"__typename":"QuiltComponent"},{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:component:custom.widget.CustomFooterSnaplogic-en-us-1750778176346":{"__typename":"CachedAsset","id":"component:custom.widget.CustomFooterSnaplogic-en-us-1750778176346","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-1750778176346":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Snaplogic_Subfooter-en-us-1750778176346","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1750955846246","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1750955846246","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:pipelines":{"__typename":"Forum","id":"board:pipelines","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:15930":{"__typename":"Conversation","id":"conversation:15930","topic":{"__typename":"ForumTopicMessage","uid":15930},"lastPostingActivityTime":"2025-05-19T22:43:15.687-07:00","solved":false},"ForumTopicMessage:message:15930":{"__typename":"ForumTopicMessage","subject":"SFTP: Worked ok then settings changed not not working","conversation":{"__ref":"Conversation:conversation:15930"},"id":"message:15930","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:15930","revisionNum":1,"uid":15930,"depth":0,"board":{"__ref":"Forum:board:snaps"},"author":{"__typename":"User","uid":407,"login":"robert_parks","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-10.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":5571},"postTime":"2018-03-27T11:00:06.546-07:00","lastPublishTime":"2018-03-27T11:00:06.546-07:00","readOnly":false},"Conversation:conversation:39921":{"__typename":"Conversation","id":"conversation:39921","topic":{"__typename":"ForumTopicMessage","uid":39921},"lastPostingActivityTime":"2025-03-06T05:09:15.045-08:00","solved":false},"ForumTopicMessage:message:39921":{"__typename":"ForumTopicMessage","subject":"SQS Consumer snap is ready all message at pipeline startup","conversation":{"__ref":"Conversation:conversation:39921"},"id":"message:39921","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:39921","revisionNum":1,"uid":39921,"depth":0,"board":{"__ref":"Forum:board:snaps"},"author":{"__typename":"User","uid":5655,"login":"vish_ch","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-7.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":667},"postTime":"2025-02-25T07:11:13.657-08:00","lastPublishTime":"2025-02-25T07:11:13.657-08:00","readOnly":false},"Conversation:conversation:39859":{"__typename":"Conversation","id":"conversation:39859","topic":{"__typename":"ForumTopicMessage","uid":39859},"lastPostingActivityTime":"2025-01-23T09:08:42.874-08:00","solved":true},"ForumTopicMessage:message:39859":{"__typename":"ForumTopicMessage","subject":"Salesforce Update REST API Throughput","conversation":{"__ref":"Conversation:conversation:39859"},"id":"message:39859","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:39859","revisionNum":1,"uid":39859,"depth":0,"board":{"__ref":"Forum:board:snaps"},"author":{"__typename":"User","uid":1302,"login":"tarena","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-9.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":1390},"postTime":"2025-01-21T17:57:18.828-08:00","lastPublishTime":"2025-01-21T17:57:18.828-08:00","readOnly":false},"Conversation:conversation:17219":{"__typename":"Conversation","id":"conversation:17219","topic":{"__typename":"ForumTopicMessage","uid":17219},"lastPostingActivityTime":"2024-11-28T08:00:35.875-08:00","solved":false},"ForumTopicMessage:message:17219":{"__typename":"ForumTopicMessage","subject":"Using Windows Authentication with SQL Server Accounts","conversation":{"__ref":"Conversation:conversation:17219"},"id":"message:17219","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:17219","revisionNum":1,"uid":17219,"depth":0,"board":{"__ref":"Forum:board:snaps"},"author":{"__typename":"User","uid":25,"login":"ebarner","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-8.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":5839},"postTime":"2017-02-21T13:43:06.377-08:00","lastPublishTime":"2017-02-21T13:43:06.377-08:00","readOnly":false},"Conversation:conversation:12924":{"__typename":"Conversation","id":"conversation:12924","topic":{"__typename":"ForumTopicMessage","uid":12924},"lastPostingActivityTime":"2024-09-27T15:14:18.066-07:00","solved":true},"ForumTopicMessage:message:12924":{"__typename":"ForumTopicMessage","subject":"Preview not available for Flow snaps","conversation":{"__ref":"Conversation:conversation:12924"},"id":"message:12924","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:12924","revisionNum":1,"uid":12924,"depth":0,"board":{"__ref":"Forum:board:snaps"},"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":30831},"postTime":"2022-04-11T10:58:47.005-07:00","lastPublishTime":"2022-04-11T10:58:47.005-07:00","readOnly":false},"QueryVariables:TopicReplyList:message:21456:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:21456:1","value":{"id":"message:21456","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1750955846246","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1750955846246","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1750955846246","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1750955846246","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1750955846246","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1750955846246","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-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1750955846246","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1750955846246","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1750955846246":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1750955846246","value":{"alt":"Powered By Khoros"},"localOverride":false},"Rank:rank:15":{"__typename":"Rank","id":"rank:15","position":14,"name":"Contributor III","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:2241":{"__typename":"User","id":"user:2241","uid":2241,"login":"Aleksandar_A","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-02-22T03:47:05.378-08: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:15"},"entityType":"USER","eventPath":"community:iaudz84835/user:2241"},"ModerationData:moderation_data:21457":{"__typename":"ModerationData","id":"moderation_data:21457","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:21457":{"__typename":"AcceptedSolutionMessage","uid":21457,"id":"message:21457","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:21456/message:21457","revisionNum":1,"author":{"__ref":"User:user:2241"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:snaps"},"parent":{"__ref":"ForumTopicMessage:message:21456"},"conversation":{"__ref":"Conversation:conversation:21456"},"subject":"Re: Mapper dynamic content","moderationData":{"__ref":"ModerationData:moderation_data:21457"},"body":"Hi @Tuomas,
\nOne way that you can try is to define the columns for each schemas and to append that object to the response documents.
\nSchemas columns object example:
\n[\n {\n \"schema1\":['a','b'],\n \"schema2\":['c','d'],\n \"schema3\":['e','f']\n }\n]\n
\nAlso, you can make this as part of a config file.
\nThen you can append this object to every document using the Join Snap with the following configuration:
\n
So, finally you can dynamically filter out the columns from the root object using the following expression in a Mapper Snap:
\n$.filter((v,k) => $.get(_schema).indexOf(k) != -1)\n
\nSample pipeline:
\n–sl-comm-dynamic-columns-parameter_2023_05_12.slp (6.8 KB)
Let me know if this helps you @Tuomas.
\nBR,
\nAleksandar.
Seems to work like a charm 🙂 Thank you!
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"42","kudosSumWeight":1,"repliesCount":0,"postTime":"2023-05-14T22:30:21.310-07:00","lastPublishTime":"2023-05-14T22:30:21.310-07:00","metrics":{"__typename":"MessageMetrics","views":4826},"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:21459":{"__typename":"ModerationData","id":"moderation_data:21459","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:21459":{"__typename":"ForumReplyMessage","uid":21459,"id":"message:21459","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:snaps/message:21456/message:21459","revisionNum":1,"author":{"__ref":"User:user:4664"},"readOnly":false,"repliesCount":2,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:snaps"},"parent":{"__ref":"ForumTopicMessage:message:21456"},"conversation":{"__ref":"Conversation:conversation:21456"},"subject":"Re: Mapper dynamic content","moderationData":{"__ref":"ModerationData:moderation_data:21459"},"body":"A follow-up question:
\nAny chance I could rename some of the columns at the same time using similar logic? 🙂
\nBR,
\nTuomas
Hi @Tuomas,
\nPlease take a look at the attached pipeline below:
\n–sl-comm-dynamic-columns-parameter_2023_05_17.slp (8.3 KB)
\nLet me know if this helps.
\nBR,
\nAleksandar.
Hi,
\nSorry, forgot to answer. But yes, this solution works just fine 🙂
\nThanks again!
\nBR,
\nTuomas