Examples of GET map function

In the following example, assume that the adapter is used in a GET map function defined command:

GET("SHAREPOINT", "-CI client_id -CS client_secret -TI tenant_id -SI site -DR drive -FO folder -FI file -CVT -CVTFMT csv -CVTQUOT """" -CVTDEL , -CVTSEP \r\n -CVTCS UTF-8",inputdata)

If the -FOLDER/-FO command is not present, the adapter will look for the SharePoint file (-FILE/-FI) directly under the mentioned drive (-DRIVE/-DR).

In the command above, the file format is assumed to be CSV. Consequently, the options -CVTFMT csv, -CVTQUOT "\"", -CVTDEL, -CVTSEP \r\n, and -CVTCS UTF-8 are specified according to CSV converter settings. If a different file format is selected, the -CVTFMT and related format-specific options will need to be adjusted accordingly.