GetFile vs OpenTextFile: Choosing the Right VBScript Method

Written by

in

“GetFile” usually refers to a function or action used to retrieve file data. The context determines whether it is a web programming API, a automation action, or a legacy system command. Here are the most common interpretations:

FileSystemFileHandle.getFile() (Web API): This is a method in the File System Access API that allows web applications to read files from a user’s local device, returning a File object.

SharePoint “Get files (properties only)” (Power Automate): An action used to search for, list, and extract metadata (file names, paths, creation dates) from SharePoint libraries.

SharePoint “Get file content” (Power Automate): A subsequent action often used in combination with “Get files” to retrieve the actual data contained within a file.

IBM TADDM getFile function: A specific function within the Common Data Model (CDM) API to capture files from a remote target, returning both content and metadata. Key Details on Usage (Power Automate Context):

Default Limitations: “Get files” actions in Power Automate often default to only 100 items.

Pagination: You can increase the limit up to 100,000 items in the action settings.

Filtering: OData syntax (e.g., FileLeafRef eq ‘filename.txt’) can be used to filter files based on metadata.

If you are trying to use a specific type of GetFile, please tell me:

Where you are seeing this (e.g., SharePoint, Javascript code, another system)?

Are you trying to read file content or just list file properties? I can then provide specific steps or code snippets.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *