# ImportInvalidPropertyValueSourceIdErrorByImportId - Catalog: `Imports` - Schema: `Basic` This is a read-only table function. The HubSpot API may not support changing the data or the Invantive UniversalSQL driver for HubSpot does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the HubSpot API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `ImportInvalidPropertyValueSourceIdErrorByImportId`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `after` | `` | ☐ | | The paging cursor token of the last successfully read resource will be returned as the `paging.next.after` JSON property of a paged response containing more results. | | `importId` | `` | ☑ | | | | `includeErrorMessage` | `` | ☐ | | | | `includeRowData` | `` | ☐ | | | ## Columns of Table Function The columns of the table function `ImportInvalidPropertyValueSourceIdErrorByImportId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `createdAt` | `int64` | Created at | ☐ | The epoch millisecond timestamp when this error was recorded. | | `dataSensitivity` | `varchar2` | | ☐ | The sensitivity level of the property, such as "non_sensitive", "sensitive", and "highly_sensitive". | | `errorMessage` | `varchar2` | | ☐ | A human-readable error message. | | `errorType` | `varchar2` | Error Type | ☐ | The classification of what went wrong during import processing. | | `extraContext` | `varchar2` | Extra Context | ☐ | Additional human-readable context about the error. | | `id` | `varchar2` | ID | ☐ | A unique, stable identifier for this specific error. | | `invalidValue` | `varchar2` | Invalid Value | ☐ | The raw string value from the import file that caused the validation failure. | | `invalidValueToDisplay` | `varchar2` | | ☐ | A convenience accessor that returns either the value from `invalidPropertyValue` or `invalidValue`, whichever is present (preferring the property value). | | `isEncrypted` | `char` | | ☐ | Whether the property value is encrypted. | | `isLargeValue` | `char` | | ☐ | Indicates if the value exceeds normal size limits. | | `knownColumnNumber` | `int32` | Known Column Number | ☐ | The zero-based column index in the import file where the error occurred | | `name` | `varchar2` | Name | ☐ | The unique property name. | | `objectType` | `varchar2` | Object Type | ☐ | The CRM object type affected by this error. | | `objectTypeId` | `varchar2` | Ojbect Type ID | ☐ | The modern object type identifier for the CRM object affected by this error. | | `persistenceTimestamp` | `int64` | Persistence Timestamp | ☐ | When the value was persisted to database, in epoch milliseconds. | | `requestId` | `varchar2` | Request ID | ☐ | A unique ID associated with this request. | | `selectedByUser` | `char` | Selected by User | ☐ | Whether the value was selected by a user. | | `selectedByUserTimestamp` | `int64` | Selected by User Timestamp | ☐ | The timestamp when the value was selected by a user, if applicable. | | `source` | `varchar2` | Source | ☐ | The origin of the property value, such as "IMPORT" or "API". | | `sourceData_containsEncryptedProperties` | `char` | | ☐ | Indicates whether this row contains values that were encrypted. | | `sourceData_fileId` | `int64` | Source Data File ID | ☐ | The unique identifier of the uploaded file containing this row. | | `sourceData_lineNumber` | `int32` | Source Data Line Number | ☐ | The 1-indexed line number of this row in the source file. Line number 0 is reserved for file-wide errors that don't correspond to a specific row. | | `sourceData_pageName` | `varchar2` | Source Data Page Name | ☐ | The name of the spreadsheet sheet/page containing this row. | | `sourceId` | `varchar2` | Source ID | ☐ | The ID of the property source indicating where it was created. | | `sourceLabel` | `varchar2` | Source Label | ☐ | A human-readable label. | | `sourceMetadata` | `varchar2` | Source Metadata | ☐ | Metadata providing additional context about the source. | | `sourceUpstreamDeployable` | `varchar2` | | ☐ | | | `TEXT` | `int64` | Text | ☐ | | | `timestamp` | `int64` | Timestamp | ☐ | When the value was set, as a 64-bit integer. | | `unit` | `varchar2` | | ☐ | The unit of measurement or context for the value. | | `updatedByUserId` | `int32` | Updated by User ID | ☐ | The ID of the user who updated the property. | | `useTimestampAsPersistenceTimestamp` | `char` | Use Timestamp as Persistence Timestamp | ☐ | Flag indicating whether to use the timestamp field as the persistence timestamp. | | `value` | `varchar2` | Value | ☐ | The property value. |