Forum Discussion

dabalka's avatar
dabalka
New Contributor II
3 years ago
Solved

JSON snap not working as expected

JSON splitter last week was working correctly. Pipeline was not edited, JSON format did not change, and yet Pipeline is crashing indicating error that JSON splitter is expecting list not an object....
  • jcornelius's avatar
    4 years ago

    @Damone
    do it all in SQL
    ie
    IF EXIST(Select id from table_x where id=@id)
    BEGIN
    UPDATE table_x set col1=@col1 where id=@id
    END
    ELSE
    BEGIN
    INSERT INTO into table_x (id,col1) values(@id,@col1)
    END