Appending CSV data to AGOL from Pro not showing geometry

AZ911GIS

I am attempting to append data to a point feature service from a CSV spreadsheet with coordinates to eventually incorporate into a script. When I run the GP tool it appears to append the data to the feature service but the geometry does not come over. Any clue as to what I am missing? When I run the the "Append Data" within the ArcGIS Online client and attempt to replicate the same GP process everything works as expected.

AZ911GIS

Kevin here are the two solutions that Esri recommended, with the first one working for me with no problem. Let me know if you do not get it up and running.

Workarounds

Create Feature Class from CSV

Add the CSV file to the map
Right click the table and click on display XY data
Fill in all the required information
Create a feature class
Use this as the input feature layer for appending the data

OR

Publish CSV file as hosted feature layer in ArcGIS Online

Click on the Add item from your computer in ArcGIS Online
Browse for the CSV file
Make sure the box for "Publish as hosted feature service" is checked
Fill in all the required fields
Click on Publish
Add the both published hosted feature layers into ArcMap
Use Append (Data Management) tool
Use the hosted feature layer created from the CSV file as the input feature layer and the other hosted feature layer as the target layer
Hit on Run.