API data addition

[Jenner09]

hi

I have a working API connection, however I want to add all new/unique data from to an existing Excel spreadsheet. Where do i start and how to go about it.

thank you

[BrandonB]

I think you could adapt this solution to yours: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-update-Insert-the-excel-output/... 

You would essentially bring in your Excel file, run a join against the primary key of the API results and look at the side of the join where the API has information that the Excel file doesn't. This would be your "new" information. Then you would just use the output data tool to the Excel spreadsheet and use the append option to add it to the file.