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...
nihil_limbadiya's avatar
nihil_limbadiya
New Contributor II
6 years ago
Copy Link

Hi Tim,

I have added some java script which read elements from Excel file to the HTML page.

For my next step i want something that if i update data in spreadsheet it should reflect changes on HTML file? I have also added function that refresh webpage every 5 sec, but can’t figure out to refresh Triggred URL in HTML file so it pulls Excel file if some changes are been made ?

if you can help me that would be great.

Please find attached Demo Display Board.zip (7.3 KB)
Thanks

tlikarish's avatar
tlikarish
Employee
6 years ago
Copy Link

From your description I think things are looking good. The JavaScript you’ve written will now poll the triggered task every 8 seconds and when that happens the pipeline will read the file and send back the results. The JavaScript will then update the contents of the page with the new results.

Attached is a screen capture where I re-upload a new spreadsheet that changed some of the values, like the manager to Mickey Mouse, and see the change on the page. Maybe the file wasn’t uploaded or the file name was changed?