Calling Custom APIs from Smartsheet form

cchurchi53221

Hi All,  we have a simply custom API which will take as input an employees ID and return their management chain.  We would like to call this API as part of a simple smartsheet form we built such that their supervisor's ID can be inserted as part of the record in the smartsheet.  Are there instructions as to how to embed a custom API into a smartsheet form?

Thanks

Paul Newcome

I can think of 2 options right off. You could create a separate form for each supervisor and use a hidden, pre-populated field for the supervisors name.

 

The other option would be to create a table of each employee with their supervisor's ID in the column to the right. You could then use a VLOOKUP or an INDEX/MATCH statement in the sheet the form populates to automatically pull in the supervisor's ID. Once the formula is entered into a row, it will auto-fill into the new rows created immediately below it.