tap-salesforce - Old/NewValue properties are of an...
# troubleshooting
j
tap-salesforce - Old/NewValue properties are of anyType, Salesforce SDK returns empty properties_schema for this. I tried to fix it in the plugin:
Copy code
if not property_schema:
        # Salesforce returns empty schema if the field is of type anyType
        # Let's set type to object to allow loading such fields
        property_schema['type'] = ['object', 'null']
But the loader fails loading values like
123
to JSONB column (PostgreSQL). Not sure how to propagate anyType to any targets properly. Any suggestions how to do it in a generally right way?
When I specify 'string' instead of 'object', it works
I believe that in the case of Salesforce it should work in all cases, but feedback is welcome!