Hi,
I'm very new to Power Automate (I come from an Alteryx background and completed what I am trying to do here in 2 minutes with that!!!)
I'm making an API call to Stripe to, in this example, pull all of the customers.
The schema looks like this;
{
"type": "object",
"properties": {
"id": {
"type": "string"
},
"object": {
"type": "string"
},
"address": {},
"balance": {
"type": "integer"
},
"created": {
"type": "integer"
},
"currency": {
"type": "string"
},
"default_source": {
"type": "string"
},
"delinquent": {
"type": "boolean"
},
"description": {},
"discount": {},
"email": {},
"invoice_prefix": {
"type": "string"
},
"invoice_settings": {
"type": "object",
"properties": {
"custom_fields": {},
"default_payment_method": {},
"footer": {},
"rendering_options": {}
}
},
"livemode": {
"type": "boolean"
},
"metadata": {
"type": "object"
},
"name": {},
"next_invoice_sequence": {
"type": "integer"
},
"phone": {},
"preferred_locales": {
"type": "array"
},
"shipping": {},
"tax_exempt": {
"type": "string"
},
"test_clock": {}
}
}
All I want to do is to make the call and have the output entered into an Excel spreadsheet.
I've scoured the internet, tried numerous "solutions" but nothing is working.
The output of 1 customer looks like this (there are many more!);
{
"object": "list",
"data": [
{
"id": "cus_OAx12FvHryCciI",
"object": "customer",
"address": null,
"balance": 0,
"created": 1688107663,
"currency": null,
"default_currency": null,
"default_source": null,
"delinquent": false,
"description": "Test Hubspot Prod",
"discount": null,
"email": "kaye@hubspotnp.com",
"invoice_prefix": "8DFC5A16",
"invoice_settings": {
"custom_fields": null,
"default_payment_method": null,
"footer": null,
"rendering_options": null
},
"livemode": true,
"metadata": {},
"name": "Kaye Test",
"next_invoice_sequence": 1,
"phone": null,
"preferred_locales": [],
"shipping": null,
"tax_exempt": "none",
"test_clock": null
},
Any help would be greatly appreciated.
Many thanks.
Share
Report
All responses (
Answers (
1,962
