Genesys Cloud - Developer Community!

 View Only

Sign Up

Retrieving duplicate rows with conversation-model-to-sql-blueprint

  • 1.  Retrieving duplicate rows with conversation-model-to-sql-blueprint

    Posted 06-27-2025 16:24

    We have been experimenting with the "conversation-model-to-sql-blueprint" tool, to hopefully flatten the JSON data being pulled with the API.  After running the docker container, populating our OAuth info, and following the instructions provided in the Blueprint document, only one record can be pulled from the "npm run invoke-api" command. Every time range used with this command returns "Error inserting conversation with ID: xxxxx duplicate key value violates unique constraint 'conversations-pkey'".

    I have attempted different date ranges from different months/years but always seem to get this error, no matter the date range (It appears to insert one row, but only the first row from the very first invoke-api command).  After multiple attempts to rebuild the container and attempt new date ranges, it results in the same "duplicate key" message and will not insert any more data after the first row.

    Is this tool still able to be used with the current API data format?  I didn't know if others have attempted to use the tool with similar results.

    Thanks!


    #DataActions
    #PlatformAPI
    #PlatformSDK

    ------------------------------
    Chad Wilson
    ------------------------------