Help Center>Studio (Foundation)

Map query fields to a SharePoint list

map step of choode define map submit approve run process

  1. Click the Mapper tab, or click the Map tab on the ribbon. You can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words).
  2. Drag each field to the Data Set panel. Or click Auto Map, and then arrange the fields by clicking Shift Up or Shift Down on the ribbon.
  3. Click Save.

    save button at top left of screen

  4. Click the folder icon next to the SharePoint URL box.

    folder icon

  5. Enter the URL of the SharePoint site.

    sharepoint site logon pad box

  6. Enter your user name and password or click the Windows Authentication check box.
  7. Click Connect, and then click OK when you receive the success message.
  8. Enter a name for the list, or choose an existing list.
  9. Click OK, and then click Save Script File.

The next step is to submit the script.

Why use a SharePoint list?

You can output to any existing SharePoint site, not just Foundation SharePoint sites, and to any SharePoint lists that have same structure as your file or to a new list or an automatically created list.

SharePoint lists are particularly useful when your data is part of a Winshuttle workflow.