Export-NAVAppTableData
Exports data from a Business Central database table to file.
Syntax
Export-NAVAppTableData
[-ServerInstance] <String>
[-Tenant <TenantId>]
-Path <String>
-TableId <Int32>
[-Force]
[<CommonParameters>]
Description
Use the Export-NAVAppTableData cmdlet to export table data from a Business Central database to a file. The data must be for a new non-company table created as part of the extension package to which the exported file will be included.
Examples
Example 1
Export-NAVAppTableData -ServerInstance BC -Path '.\' -TableId 10000
This example exports the data from the table with the ID 10000 in the default tenant database for server instance BC to a TAB10000.navxdata file in the current folder.
Parameters
-Force
Forces the command to run without asking for user confirmation to overwrite an existing export file at the given path.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Path
Specifies the path to the folder where the export file should be written. A data file with a name of TAB<TABLEID>.navxdata will be created. (Example: TAB10000.navxdata)
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ServerInstance
Specifies the Business Central Server instance from which the data will be exported, such as BC.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-TableId
Specifies the table ID to export. The ID must be for a new non-company table created as part of the extension.
Type: | Int32 |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Tenant
Specifies the tenant from which to export data. If the server instance is configured for single tenant, do not set the parameter.
Type: | TenantId |
Aliases: | Id |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for