Import from REST API

  • 45Views
  • Last Post 16 December 2021
0
votes
Dan Barker posted this 15 December 2021

I am not sure what format the metadata needs to be in. We need to make a get request to this link

https://{companyname}.chargify.com/mrr_movements.json?&per_page=50&direction=DESC

Ideally, we would loop through the first few pages to get enough data but not absolutely necessary.

Authentication is basic authentication.

The response is in JSON and the records we need are under mrr.movements

If we can flatten the data that would be helpful.

Here is the rest documentation: https://reference.chargify.com/v1/mrr/mrr-movements

 

 

Order By: Standard | Newest | Votes
0
votes
Dan Barker posted this 15 December 2021

{ "mrr": { "page": 1, "perpage": 1, "totalpages": 4148, "totalentries": 4148, "currency": "USD", "currencysymbol": "$", "movements": [ { "timestamp": "2021-12-15T14:11:42-05:00", "amountincents": 31500, "amountformatted": "$315.00", "description": "description information", "category": "newbusiness", "breakouts": { "planamountincents": 31500, "planamountformatted": "$315.00", "usageamountincents": 0, "usageamountformatted": "$0.00" }, "lineitems": [ { "productid": 123456456, "componentid": 0, "pricepointid": 0, "name": "name of produt", "mrr": 24500, "mrrmovements": [ { "amount": 24500, "category": "newbusiness", "subscriberdelta": 1, "leaddelta": 0 } ], "quantity": 1.0, "prevquantity": 0.0, "recurring": true }, { "productid": 12342135, "componentid": 4321541, "pricepointid": 0, "name": "Additional Plus User", "mrr": 7000, "mrrmovements": [ { "amount": 7000, "category": "newbusiness", "subscriberdelta": 0, "leaddelta": 0 } ], "quantity": 1.0, "prevquantity": 0.0, "recurring": true } ], "subscriptionid": 32145431, "subscriber_name": "name of sub" } ] }

 

}

0
votes
Nataliia Nikulina posted this 16 December 2021

Hello Dan,

 

Thank you for contacting Skyvia Support team.

We have replied to you via email. Please check your mailbox. 

Let us know if you need any further assistance. 

 

Best regards,

Nataliia,

Customer Support Engineer 

Close