Forum Discussion

Henchway's avatar
Henchway
Contributor
5 years ago

"Sort path" based on dynamic columns // sort & diff

Hi, i’m having the following challenge: I’m pulling data from a REST API as well as SQL tables. Before grabbing the actual objects, i’m grabbing “Object Types” from the REST API to know which t...
diff
Supratim's avatar
Supratim
Contributor III
5 years ago

@Henchway As there are some limitation to use expression in diff snap, one work around I can think about (even though it’s might not very good approach), use Router based on the object type then add the relevant key for every diff snap. It might help you to avoid creating 6 different pipeline. 🙂

  • Henchway's avatar
    Henchway
    Contributor
    5 years ago

    Thanks, briefly i ended up doing that.
    In the end, i introduced a new field to the database tables referencing the key of the items from the rest service, that way i can be sure that it will exist and that it’s sortable.

    Best regards
    Thomas