#wax_api
alpine helmBOT
đ Welcome to your new thread!
â˛ď¸ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.
âąď¸ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.
đ This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1483527927810359366
đ Have more to share? Add more details, code, screenshots, videos, etc. below.
tiny fable
Hi there,
Sigma is normally not our wheelhouse. I would recommend reaching out to Stripe support https://support.stripe.com/?contact=true. There a Sigma experts who can help better than we could.
dapper basin
what I need may not even necesarilly have to be done with Sigma --- Our 'main' booked sales data comes from NetSuite -- I am trying to essentially add our sales/returns from stripe transactions to this same table so I essentially want to return all transactions sale/refunds, date, customer, etc etc... so that I can append this to our other sales source -- is this something more easily doable with sigma or something you all could help with
tiny fable
Where does your netsuite data live? In your own database/warehouse? are you using the netsuite connector?
dapper basin
yes.. it lives in our own warehouse
no -- we are mainly extracting data from saved searches or workbooks
tiny fable
The best approach would probably be using Sigma. The only other way I see right now would be the API, using the List all balance transcations and the Retrieve charge/refund API, but those will be multiple calls which is not scalable in the end.
But for Sigma I would have to refer you to our support team. Same for the connector (if that would be of interest to you) too since you might be able to automate this flow using the connector.
alpine helmBOT