Issue:
Sometimes in the OneDrive as a source, clients face difficulty in defining the path of the file that they would like to use. This guideline will help you to overcome this issue.
Solution:
The path would be the folder in their oneDrive account, for e.g. if there is a folder called /testing/ (SS below)
and within that folder if there is a csv file called test.csv → (SS1 below)
Then this is how the file can be extracted:
In the oneDrive connection setup step, they will fill their cid= (which is found in their oneDrive URL (mentioned in our docs here - check point 3, Drive ID) and then to access the files within the folder testing, the path will be defined as such: /testing/ (SS2 below)
Finally in the file setup step, they will select the file format, whether it is a csv, json, xml, xlsx or parquet file. Here in my case, it is a csv format, so I select that and then in the file name I define the name of the file as it is shown in my oneDrive account (test.csv, SS1) → note if the file name contains the extension type, then please do include it (here in this case it is .csv). (SS1) (SS3 below).
