Forum Discussion

dmiller's avatar
dmiller
Former Employee
4 years ago

Pipeline Directory Generator

Created by Chris Ward, SnapLogic

This pipeline generates a Google Sheet containing key information relating to all Pipelines within a customers org. This allows customers to maintain both a consolidated & up to date view of all Pipelines within a specific Org alongside its last run status and other important metadata. The Pipeline would need to be scheduled to run on a set cadence.

The pattern could be further adapted to write the output to an alternative destination or even consumed externally as an API.

Configuration

The following pipeline parameters can be used to configure certain aspects of the Pipeline.

  • OrgName
  • GoogleSheetName
  • GoogleWorksheetName

Sources: SnapLogic API & Metadata Snaps
Targets: Google Sheets
Snaps used: SnapLogic Metadata, REST Get, JSON Splitter, Mapper, Join, Sort, Google Sheets Worksheet Writer

Downloads

Pipeline Directory Generator.slp (19.7 KB)

  • Ganesh's avatar
    Ganesh
    New Contributor II
    6 years ago

    Hi,
    You can try Array.toString() function if its an array type or use string.replaceAll() function to achieve this.

  • ronmwhite's avatar
    ronmwhite
    New Contributor II
    6 years ago

    It is hard to tell by what has been posted here, but, perhaps you need a JSON Splitter. At the right JSON path, you should get the unique GUID values required downstream. Feel free to ping me if you need any assistance. Thanks.

  • Kulashekharan's avatar
    Kulashekharan
    New Contributor II
    6 years ago

    Use array.join(“,”) or array.toString() to achieve what you asked for. Join will allow you to change the delimiter. Keep in mind This returns one string value

Recent Discussions