search

flexiodata / flexio-web-app

Flex.io Web App
https://www.flex.io/app
MIT License
5 stars 2 forks source link

Dev Outreach - Liam's Auction Pipe #304

Open wanderslth opened 6 years ago

wanderslth commented 6 years ago

Please provide a JS SDK pipe example for Liam's legacy auction website pipe. I'd like to email him to show him what we have now compared to before and start a dialog.

Here's the old pipe (he had two that were nearly identical):

(input: google sheet)
input from: mnywz41t2k7b file: /Auction results for Wagga_NoSummary
calc formula: to_number(a,'9V999D99') name: a_numeric type: numeric
sort col: a_numeric desc
limit value: 1
select col: a_numeric
(output: API endpoint)

I'd like to recreate these with our JS SDK. However, a variety of things in this pipe are unavailable, including google sheets (security issue), calc sort limit and probably rename of a column.

The above was probably a hack to begin with -- so we can think through the best method with the new SDK. The actual pipe simply needed to do the following upon website load:

1. Read data from google sheets
2. Get the highest value from the amount column
3. Post highest amount to website via api endpoint for display
dzwillia commented 6 years ago

@wanderslth I take it Liam has come and gone. I don't think we've maintained any contact with him. Would he have any interest in our current approach? If not, let's close this issue.

wanderslth commented 6 years ago

I think this might be an interesting thing to try @alwillia as part of the dev outreach -- with python it would be trivial and streamlined to grab a metric from google sheet. Plus, you could show hooking up to zapier via webhook if we wanted.