Hello, I am trying to use the mapper to hide a fie...
# troubleshooting
y
Hello, I am trying to use the mapper to hide a field of a nested object, but it is not working. Below are my settings.
Copy code
- name: meltano-map-transformer
  variant: meltano
    pip_url: git+<https://github.com/MeltanoLabs/meltano-map-transform.git>
    executable: meltano-map-transform
    mappings:
    - name: hide-address
      config:
        stream_maps:
          users:
            profile__homeContactAll: null
Here is the users object
Copy code
{'id': 123, "profile": {"zipCode": "EC2V 6EE", "homeContactAll": "1 Baker St., London"}}
c
This is a known issue in meltano https://github.com/meltano/meltano/issues/6382
y
Thanks, @christoph, I don’t think this is the cause. There is an issue with the mapper not finding the key for the nested objects. Please see below where I made some modifications.
Copy code
- name: meltano-map-transformer
  variant: meltano
    pip_url: git+<https://github.com/MeltanoLabs/meltano-map-transform.git>
    executable: meltano-map-transform
    mappings:
    - name: hide-address
      config:
        stream_maps:
          users:
            profile__homeContactAll: "id"
            homeContactAll: "id"
Below is the result
Copy code
{'id': 123, "profile": {"zipCode": "EC2V 6EE", "homeContactAll": "1 Baker St., London"}, profile__homeContactAll: 123, homeContactAll: 123 }
Any help on this please?