marcos_wesley
08/17/2022, 5:00 PMproducts.
The endpoints that I will use are:
"products": "/crm/v3/objects/products",
"products_properties": "/crm/v3/properties/products",
"products_v3_properties": "/crm/v3/properties/products",
I’m stuck on the transformation part where I get the record.
record = bumble_bee.transform(source, schema, mdata)
When I run the command TAP_HUBSPOT__SELECT='["products.*"]' meltano invoke tap-hubspot I get the following output:
WARNING Removed 10 paths during transforms:
archived
createdAt
id
property_createdate
property_description
property_hs_lastmodifieddate
property_hs_object_id
property_name
property_price
updatedAt
WARNING Removed paths list: ['archived', 'createdAt', 'id', 'property_createdate', 'property_description', 'property_hs_lastmodifieddate', 'property_hs_object_id', 'property_name', 'property_price', 'updatedAt']
CRITICAL Errors during transform
properties.createdate: 2021-01-13T17:43:00.701Z does not match {'type': 'object', 'properties': {'value': {'type': ['null', 'string'], 'format': 'date-time'}, 'timestamp': {'type': ['null', 'string'], 'format': 'date-time'}, 'source': {'type': ['null', 'string']}, 'sourceId': {'type': ['null', 'string']}}}
I believe it is related to the custom_schema generated in the load_schema() function, has anyone been through this could help me?