Forum Discussion

nihil_limbadiya's avatar
nihil_limbadiya
New Contributor II
6 years ago

Creating a Pipeline that reads the spreadsheet and return data within

Hi, I am Database Administrator/Developer and i am pretty new to snaplogic and i am self learning it at a moment.I got quick question on how to develop a snaplogic. Query :- would like to add som...
tlikarish's avatar
tlikarish
Employee
6 years ago
Copy Link

Hey Nihil,

I went ahead and tried to tailor an example that was closer to your use case. Try and follow these steps to get going.

  1. Import the attached project to your org. Inside is the spreadsheet file, a pipeline that can read the file, and a triggered task for the pipeline. This is what will be used to feed data to your display board demo.

  2. Navigate to the imported project and view the Task details in manager. Copy the cloud url and the bearer token into the updated HTML I attached. Look for the variables TASK_URL and TOKEN.

  1. Configure your org’s CORS settings to allow accessing the triggered task from the domain that your display board is hosted on.

  2. Load the HTML page in a browser, you should see an alert pop up with the data from the spreadsheet.

Updated HTML: Demo Display Board.zip (8.6 KB)
Project to Import: projects_Spreadsheet-Example.zip (8.2 KB)

  • nihil_limbadiya's avatar
    nihil_limbadiya
    New Contributor II
    6 years ago
    Copy Link

    Thanks Tim,

    Much Appriciated for your help… Thanks I can go ahead and build whole pipeline.

    Thanks
    Regards
    Nihil