Hi all! I’m working on implementing a new entity f...
# troubleshooting
m
Hi all! I’m working on implementing a new entity for the tap-hubpot, the entity is
products
. The endpoints that I will use are:
Copy code
"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.
Copy code
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:
Copy code
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?