\nBojan
","board":{"__ref":"Forum:board:pipelines"},"conversation":{"__ref":"Conversation:conversation:21994"},"author":{"__typename":"User","login":"bojanvelevski"},"postTime":"2021-12-29T10:20:49.818-08:00","kudosSumWeight":1}},{"__typename":"MessageEdge","cursor":"MjUuOHwyLjF8b3w1fDE0OjAsMzk6MXwy","node":{"__typename":"ForumReplyMessage","uid":21996,"body":"Thanks for your response @bojanvelevski.
\nI am trying to test and understand this sample pipeline. Can you kindly give me a high-level explanation of it? I don’t recognize the code in the mapper snap and its doing a lot as seen in the below pipeline statistic (CPU% and memory).
\n
\nThe [Binary to Document] and [Mapper] snaps is a manual replacement for [CSV Parser] snap? Where can I find documentation for the syntax used?
Hey @JPaps,
\nI’m using the Binary to Document snap to get a stringified version of the CSV where rows (records) are separated by /r/n. That’s why in the expression, I’m first splitting the string on ‘/r/n’, that way I can get the headers + the records separately. The rest is a logic to fill the missing headers with ‘field_’ + random number, which in your case might be a problem due to high number of records. Anyway, the expression is creating objects out of the Headers and the Records. But because sl.zipObject is automatically adding nulls if there’s no value (but in our case we need replacement for the missing header, not value) i created the object with key/value reversed, meaning:
\n{\"value\":\"key\"}
If there’s a missing key, than the expression will automatically add null, which is later replaced with ‘field_’+random 2 digit number. And after filling the missing value (soon to be key), I’m reversing the object :
\n{\"key\":\"value\"}
It’s rough, and for smaller number of records is working, but it needs to be tested out with large number of records like in your case.
\nRegards,
\nBojan
Hi, I am trying to parse a CSV that is auto-generated by a legacy system. The CSV has no headers.
\nThe problem is, the system conditionally adds columns to individual records. So, the CSV sometimes has records with more columns than others. This causes Snaplogic’s CSV Parser to fail (it doesn’t parse the whole file). The parser will only parse up to the row number where the record with the additional columns is. Below is the error message:
\n
This sounds far-fetched but is there a way to automate a solution to this problem? Perhaps by being able to conditionally control the columns before the document hits the CSV Parser?
","body@stringLength":"660","rawBody":"Hi, I am trying to parse a CSV that is auto-generated by a legacy system. The CSV has no headers.
\nThe problem is, the system conditionally adds columns to individual records. So, the CSV sometimes has records with more columns than others. This causes Snaplogic’s CSV Parser to fail (it doesn’t parse the whole file). The parser will only parse up to the row number where the record with the additional columns is. Below is the error message:
\n
This sounds far-fetched but is there a way to automate a solution to this problem? Perhaps by being able to conditionally control the columns before the document hits the CSV Parser?
","kudosSumWeight":0,"postTime":"2021-12-29T09:07:51.600-08: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":"MjUuOHwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:csv","text":"csv","time":"2023-07-25T02:37:12.714-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:21994_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":3290},"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":"Hi, I am trying to parse a CSV that is auto-generated by a legacy system. The CSV has no headers. \n The problem is, the system conditionally adds columns to individual records. So, the CSV sometimes ...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuOHwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:21995"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:21994":{"__typename":"Conversation","id":"conversation:21994","solved":false,"topic":{"__ref":"ForumTopicMessage:message:21994"},"lastPostingActivityTime":"2021-12-30T01:17:26.968-08:00","lastPostTime":"2021-12-30T01:17:26.968-08:00","unreadReplyCount":3,"isSubscribed":false},"ModerationData:moderation_data:21994":{"__typename":"ModerationData","id":"moderation_data:21994","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:21994_1":{"__typename":"Revision","id":"revision:21994_1","lastEditTime":"2021-12-29T09:07:51.600-08:00"},"CachedAsset:theme:customTheme1-1757777137592":{"__typename":"CachedAsset","id":"theme:customTheme1-1757777137592","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":"IntegrationNation-logo-color-1757025181508.svg","imageLastModified":"1757025184078","__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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1757777136793","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:pipelines-1757777135927":{"__typename":"CachedAsset","id":"quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:pipelines-1757777135927","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1757777136793","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:1757777136318":{"__typename":"CachedAsset","id":"quiltWrapper:snaplogic.prod:Common:1757777136318","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":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"logoLinks":[],"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":"unset","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":"var(--lia-bs-primary)","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"unset","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":"0","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1757777136793","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-1757777148280":{"__typename":"CachedAsset","id":"component:custom.widget.CustomFooterSnaplogic-en-us-1757777148280","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-1757777148280":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Snaplogic_Subfooter-en-us-1757777148280","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1757777136793","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1757777136793","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-09-16T12:17:47.520-07:00","solved":true},"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":61},"postTime":"2025-07-29T14:13:40.344-07:00","lastPublishTime":"2025-07-29T14:13:40.344-07:00","readOnly":false},"Conversation:conversation:40407":{"__typename":"Conversation","id":"conversation:40407","topic":{"__typename":"ForumTopicMessage","uid":40407},"lastPostingActivityTime":"2025-09-03T07:20:18.541-07:00","solved":true},"ForumTopicMessage:message:40407":{"__typename":"ForumTopicMessage","subject":"How to get filename from file reader","conversation":{"__ref":"Conversation:conversation:40407"},"id":"message:40407","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40407","revisionNum":1,"uid":40407,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5319,"login":"omiaye","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-12.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":54},"postTime":"2025-09-01T13:06:25.515-07:00","lastPublishTime":"2025-09-01T13:06:25.515-07:00","readOnly":false},"Conversation:conversation:40401":{"__typename":"Conversation","id":"conversation:40401","topic":{"__typename":"ForumTopicMessage","uid":40401},"lastPostingActivityTime":"2025-08-29T02:17:15.917-07:00","solved":true},"ForumTopicMessage:message:40401":{"__typename":"ForumTopicMessage","subject":"Generate expression file from database query","conversation":{"__ref":"Conversation:conversation:40401"},"id":"message:40401","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40401","revisionNum":1,"uid":40401,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":6165,"login":"XanderVR","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":72},"postTime":"2025-08-25T06:44:03.800-07:00","lastPublishTime":"2025-08-25T06:44:03.800-07:00","readOnly":false},"Conversation:conversation:40044":{"__typename":"Conversation","id":"conversation:40044","topic":{"__typename":"ForumTopicMessage","uid":40044},"lastPostingActivityTime":"2025-08-25T08:20:15.814-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":698},"postTime":"2025-04-14T09:19:56.464-07:00","lastPublishTime":"2025-04-14T09:19:56.464-07:00","readOnly":false},"Conversation:conversation:40398":{"__typename":"Conversation","id":"conversation:40398","topic":{"__typename":"ForumTopicMessage","uid":40398},"lastPostingActivityTime":"2025-08-25T06:24:17.008-07:00","solved":true},"ForumTopicMessage:message:40398":{"__typename":"ForumTopicMessage","subject":"401 error with HTTP Client and NTLM","conversation":{"__ref":"Conversation:conversation:40398"},"id":"message:40398","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40398","revisionNum":1,"uid":40398,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":8057,"login":"rmaron","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-7.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":48},"postTime":"2025-08-22T08:34:13.602-07:00","lastPublishTime":"2025-08-22T08:34:13.602-07:00","readOnly":false},"QueryVariables:TopicReplyList:message:21994:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:21994:1","value":{"id":"message:21994","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1757777136793","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1757777136793","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1757777136793","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1757777136793","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1757777136793","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1757777136793","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-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1757777136793","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1757777136793","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1757777136793":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1757777136793","value":{"alt":"Powered By Khoros"},"localOverride":false},"Rank:rank:14":{"__typename":"Rank","id":"rank:14","position":13,"name":"Valued Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1622":{"__typename":"User","id":"user:1622","uid":1622,"login":"bojanvelevski","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-01-27T00:06:18.031-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":{"__ref":"Rank:rank:14"},"entityType":"USER","eventPath":"community:iaudz84835/user:1622"},"ModerationData:moderation_data:21995":{"__typename":"ModerationData","id":"moderation_data:21995","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:21995":{"__typename":"ForumReplyMessage","uid":21995,"id":"message:21995","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:21994/message:21995","revisionNum":1,"author":{"__ref":"User:user:1622"},"readOnly":false,"repliesCount":2,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:21994"},"conversation":{"__ref":"Conversation:conversation:21994"},"subject":"Re: CSV Parser Troubling Error (Cannot complete CSV data parsing)","moderationData":{"__ref":"ModerationData:moderation_data:21995"},"body":"Hey @JPaps,
\nParsing unconventional CSV-s can be tricky. Check if this sample pipeline works for you:
\nParse Unconventional CSV_2021_12_29.slp (5.3 KB)
\nRegards,
\nBojan
Thanks for your response @bojanvelevski.
\nI am trying to test and understand this sample pipeline. Can you kindly give me a high-level explanation of it? I don’t recognize the code in the mapper snap and its doing a lot as seen in the below pipeline statistic (CPU% and memory).
\n
\nThe [Binary to Document] and [Mapper] snaps is a manual replacement for [CSV Parser] snap? Where can I find documentation for the syntax used?
Hey @JPaps,
\nI’m using the Binary to Document snap to get a stringified version of the CSV where rows (records) are separated by /r/n. That’s why in the expression, I’m first splitting the string on ‘/r/n’, that way I can get the headers + the records separately. The rest is a logic to fill the missing headers with ‘field_’ + random number, which in your case might be a problem due to high number of records. Anyway, the expression is creating objects out of the Headers and the Records. But because sl.zipObject is automatically adding nulls if there’s no value (but in our case we need replacement for the missing header, not value) i created the object with key/value reversed, meaning:
\n{\"value\":\"key\"}
If there’s a missing key, than the expression will automatically add null, which is later replaced with ‘field_’+random 2 digit number. And after filling the missing value (soon to be key), I’m reversing the object :
\n{\"key\":\"value\"}
It’s rough, and for smaller number of records is working, but it needs to be tested out with large number of records like in your case.
\nRegards,
\nBojan