Forum Discussion

swright's avatar
swright
New Contributor III
3 years ago
Solved

Transforming JSON Output to Payload for Slack App

I have a pipeline that outputs a json file that I would like to reformat into a payload for a Slack webhook app. It’s for an outlist and the json output list a person’s fullName with startDate and en...
transform
  • Abhishek_Soni37's avatar
    Abhishek_Soni37
    3 years ago

    Hey @swright

    I was able to generate the expected o/p but what to do with the first two elements, I could’ve hardcoded it but I didn’t cause I think you are getting that data dynamically from somewhere.
    I’ve attached the sample pipeline with the expression in it.

    Test_Expression_2023_06_05.slp (5.6 KB)

    I hope this helps 🙂

    Cheers

swright's avatar
swright
New Contributor III
3 years ago

I successfully managed to get the pipeline functioning by utilizing FTP snaps and a Unix Snap to execute a Perl script I developed for the transformation process. However, I am still curious about achieving the same outcome within Snaplogic itself. I attempted using Script snaps with Javascript or Python, but encountered numerous errors that I believe were caused by how the Script snaps implement those languages.

It seems that I frequently find myself needing to rely on external tools instead of utilizing Snaplogic for such processing tasks. I would appreciate exploring how this could have been accomplished within Snaplogic, both with and without the use of a Script snap.

I uploaded sample files with what is to be transformed (sample_incomming_data.json) and what it is to be transformed to (sample_output_payload.json).

sample_incomming_data.json (4.3 KB)
sample_output_payload.json (7.2 KB)

For reference I also uploaded the Perl script that I wrote that successfully does the transformation (transform.pl.txt). This uses the Perl JSON module so I had to install it:

sudo yum install perl-JSON

transform.pl.txt (2.7 KB)

Scott

  • Abhishek_Soni37's avatar
    Abhishek_Soni37
    Contributor
    3 years ago

    Hey @swright

    I was able to generate the expected o/p but what to do with the first two elements, I could’ve hardcoded it but I didn’t cause I think you are getting that data dynamically from somewhere.
    I’ve attached the sample pipeline with the expression in it.

    Test_Expression_2023_06_05.slp (5.6 KB)

    I hope this helps 🙂

    Cheers