Skip to content

Format data for data source type table #254

@GautierFR

Description

@GautierFR

Hi,
I couldn’t find any documentation describing how to format data for data sources of type table.

By experimenting (and checking a bit of the code), I discovered that:

  • Each column can be accessed individually using a variable like $<column_name>$.

  • If no custom format is specified, the whole record is printed to stdout as a JSON object.

However, I couldn’t find any information about how to explicitly retrieve or format the entire JSON record inside a custom format definition.

For example, this works as expected:

[tabctc]
type=table
table=contact
schema=gdumas
destinations=test_out
format={"ID":"$ID$","NOMCTC":"$NOMCTC$","PRECTC":"$PRECTC$","MAILCTC":"$MAILCTC$","TELCTC":"$TELCTC$"}

But I would like to know if there is a variable or placeholder I can use to access the full JSON record directly (instead of listing every column manually).

Is there such a variable available (e.g. something like $JSON$ or $RECORD$)?
If not, could this feature be added or documented?

Thanks!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions