Issue fetching null or empty records from a stream's response.

[himanshudube97]

Topic

No response

Relevant information

While testing the Airbyte no-code connector, we noticed that the API responses contain many fields, including some with null or empty values. However, when we switch to the Records tab in Airbyte, those null or empty fields are missing.

This seems to happen because Airbyte omits fields with null values from the response to reduce payload size.

But in our use case, we want all fields to be included in the records — even if their values are null or empty — to maintain schema consistency.

Is there a way to configure Airbyte to preserve all fields, including those with null or empty values, in the final output?

[himanshudube97]

For reference: Ummeed's synergy connect stream

Important: This command can only be run by one of the repository admins:
Usage: ./tools/bin/get_repo_admins.sh <personal_access_token>

[fatchat]

Airbyte infers the schema from the responses it sees when you fetch records in the UI builder. You can then make your own changes to that schema by switching from the Configuration to the Declared Schema tab:

> > Important: This command can only be run by one of the repository admins: > Usage: ./tools/bin/get_repo_admins.sh

[siddhant3030]

@fatchat rohit I tried to configure the schema but still it was not returning the same fields. Like I added the ecosystem field but then it doesn't come in the records

> > Important: This command can only be run by one of the repository admins: > Usage: ./tools/bin/get_repo_admins.sh