Import data from sharepoint folder fail

[JimmyHsueh]

Hi ,

Currently I'm trying to build our BU dashboard for tracking all projects' bug/task.

So my workflow first is to feed in one demo project data by using web link surely it works by paste single csv URL from sharepoint folder. 

After I almost complete my dashboard settings, It's about time to add more project into my database. I create more project csv files into the previous sharepoint folder, then problem occurs. In the import option I pick the "SharePoint folder" then I paste my sharepoint link into the URL but this time it feedback link fail with wording like [detailed information: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: request failed: ...]. So I would like to know does there exist another way to import series data from website folder? Or a better choice to solve my problem?

[christinepayton · Accepted solution]

The folder connector is meant to combine a bunch of files with the same structure. Is that what you're trying to do here? Or are they different types of data for each file? 

The SharePoint folder connector wants the root site path (e.g. https://whatever.sharepoint.com/sitename ), not the file path. You can still connect using file paths to files stored in SharePoint, but not with the SP folder connector. My usual technique for the latter is to just use the desktop version of the connector and then go into the source step and paste in the cloud path (example here). 

[SamWiseOwl]

Hi @JimmyHsueh 

Can you show a screen shot of your applied steps.
Which step is it breaking on?

Are you modifying the existing query or creating a new one?