![]() This will download the files for you and then you can perform excel operations directly. Once all the file id's are determined, iterate through them one by one and you can use the export function of the Drive API itself to download the files as a bit stream and then you can write the same to any given excel file. Pass the aprameter and perform the operation. There all the functions accept a parameter called as 'sheetid' which is same as the current 'fileid' you are working on. Once all the file id's are determined, iterate through them one by one and you can use the API functions of Google Sheets API. (Determine the drive id first using the first step) Second, you can use the list function call of files from Google Drive API which will return you all the file ID's at the respective 'driveid' parameter which you provide. You can filter out the correct drive id where you want to work First, you can use the list function call of drives from Google Drive API which will return you all the drive ID's in your Google Drive account. Theoretically there are two straightforward solutions that come to my mind: You can refer to the documentations in each of the DX exchange connector page which explains it clearly. ![]() For integrating both these services with Blueprism you can use the the DX exchange connectors as well: Google Drive V3 and Google Sheets V4įor using the services, you need to create a service account in your Google Workspace and then you can enable the APIs and generate the private keys which will be used in the credential manager of your Blue Prism client. For this specific requirement you can use both Google Drive API and Google Sheet API. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |