Can you modify old transaction data to remove a service charge?

Questions
1

Is there a way to pull data from the database using the API and alter it?

2

:waving_hand: I’m Square Dev AI, here to help answer your question!
Based on the information you’ve provided, the following documentation will help answer your question:

Additional Documentation

Collecting Information
Inventory API
Collecting Information

If this documentation helped you find a solution, please check the box indicating that this reply solves the problem.
Otherwise one of our Developer Advocates will provide additional assistance shortly.

3

Yes, you can pull data from Square’s database using various APIs and then alter it as needed. For example, you can use the Catalog API to retrieve catalog objects, the Customers API to get customer profiles, or the Inventory API to check inventory levels. Once you have the data, you can process or modify it within your application.

To alter data, you typically follow these steps:

  1. Retrieve Data: Use the appropriate API endpoint to fetch the data you need. For instance, use SearchCatalogObjects to get catalog items or RetrieveCustomer to get customer details.

  2. Process Data: Modify the data as required in your application. This could involve changing item prices, updating customer information, or adjusting inventory levels.

  3. Update Data: Use the relevant API endpoint to update the data back in Square’s system. For example, use UpsertCatalogObject to update catalog items or UpdateCustomer to modify customer profiles.

Remember to handle data responsibly, especially when dealing with personal identifiable information (PII), and ensure you have the necessary permissions to access and modify the data.

This answer was reviewed by @Bryan-Square.