Good morning,
I'm working with Bridge and still getting used to the capabilities, and more importantly, the syntax. Perhaps this is not the best option as I am generally pretty good with code, and there is a lot that seems to be hidden or overly simplified.
So my "simple" question is how do I set up a Bridge to add data from a new row in Smartsheet to a SharePoint list.
Steps I've taken:
- On the Integrations page, Connect and Authorize the SharePoint extension. But I never put in a site name or path, so I'm not clear how Smartsheet or SharePoint knows what I authorized.
- Set up a Bridge trigger on an Intake sheet "When Rows Are Added"
- Set up a "Get Row" module and used {{runtime.sheetID}} and {{runtime.event.rowID}} but I have not used this syntax before, and I have not confirmed that it will work.
- Set up a "SharePoint: Create List Item" module and attempted to fill it out.
- I do not know Site ID or List ID, so I attempted the two methods suggested on the SharePoint module reference | Smartsheet Learning Center page
And that's where I am stuck. Either I get "Plugin Error ERR_PROCESSING : failed to execute extension module : Invalid request" when using a full site path (http://example.sharepoint.com/Lists) or "The provided path does not exist, or does not represent a site" when using the Relative URL, as suggested in the pop-up (/Lists or /Lists/).
It feels like the problem may have stemmed from the very first step with the Integration, but I can't figure out how to determine that.