Reply
Emerging Member
Posts: 118
Registered: ‎03-19-2018
Kudos: 18
Solutions: 4

Re: UCRM API

Understood, thank you. @UBNT-Petr
HTML, SCSS, Javascript(Ember.js), Ruby(Ruby on Rails), PHP
New Member
Posts: 35
Registered: ‎12-13-2017
Kudos: 31

Re: UCRM API

Is there a way to change the "Last invoiced date" through the API?

Ubiquiti Employee
Posts: 3,158
Registered: ‎12-10-2015
Kudos: 1116
Solutions: 250

Re: UCRM API

@kysevenle this parameter is one of those related to current invoicing status, these cannot be modified with API for now. Do you need to do some kind of batch change for multiple services or is there another important use case?
Member
Posts: 214
Registered: ‎03-09-2009
Kudos: 7

Any way to use API from UCRM to generate invoices into our current billing software?

We already use a good billing software. Is there any way to use API from UCRM to generate invoices into our current billing software?

Ubiquiti Employee
Posts: 3,158
Registered: ‎12-10-2015
Kudos: 1116
Solutions: 250

Re: Any way to use API from UCRM to generate invoices into our current billing software?

You can use UCRM API to modify or manage data, invoices etc. in UCRM. You would need 3rd party API to interact with another tool. And of course, you can connect both tools.
New Member
Posts: 36
Registered: ‎05-30-2014
Kudos: 35
Solutions: 5

Re: UCRM API

Is there any method for pulling the Census Block GEOID of a service? If not, could it be added to the Services api call?

When running the FCC report, we ran into issues where some customers didn't have one set, and are now in the process of trying to track down who is missing. If this were exposed, we could easily enumerate the list to find missing entries, or potentially generate our own reports that could integrate with other data outside of UCRM.

Ubiquiti Employee
Posts: 3,158
Registered: ‎12-10-2015
Kudos: 1116
Solutions: 250

Re: UCRM API

@CC_DKP you could generate the FCC report to get this data, or am I missing something?
New Member
Posts: 36
Registered: ‎05-30-2014
Kudos: 35
Solutions: 5

Re: UCRM API

@UBNT-Petr We were having issues with the FCC report not whating to generate or being incorrect due to the data being missing or wrong in UCRM (possibly a product of moving the data forward over time from early versions of UCRM).

 

A lot of our API use is writing data integrity reports (making sure everything has a service device with valid interfaces, Distance between CPE and towers are sane, etc.). Being able to pull the Census Block GEOID would allow us to programatically verify it is present, and identify which customers need manual correction.

Highlighted
Ubiquiti Employee
Posts: 3,158
Registered: ‎12-10-2015
Kudos: 1116
Solutions: 250

Re: UCRM API

I see, we will most likely add the census block codes to the service API endpoint. However, note that no data missing or disappear due to previous UCRM upgrades. You may just want to check:
- The technology of transmission attribute in all your Service Plans configuration
- Addresses for clients or client's services
New Member
Posts: 27
Registered: ‎08-29-2017
Kudos: 1

Re: UCRM API

Similar to @kysevenle's request, can the Last invoiced date be retrieved?  We have instances where disabling the "Prorated separately" on creating a new service invoiced for current month (prorated), next month and the following month after that.  We only wanted this month (prorated) and next month.  If you don't go back to the service to fix it, they are billed twice.  I need to create an audit report using the API to find out who these customers are.

 

Thank you for a great product and service to the community!  We find UCRM very useful to use with Ubuiqiti products.

Ubiquiti Employee
Posts: 3,158
Registered: ‎12-10-2015
Kudos: 1116
Solutions: 250

Re: UCRM API

Hi @jcanady Last invoiced date will be retrievable in 2.14.
as a temporary solution, you could use this query. but be careful, when accessing the UCRM database.

 

sudo docker exec -t ucrm_web_app_1 bash -c 'export PGPASSWORD="${POSTGRES_PASSWORD}" && psql -d "${POSTGRES_DB}" -h "${POSTGRES_HOST}" -p "${POSTGRES_PORT}" -U "${POSTGRES_USER}" -t -c "SELECT client_id, invoicing_last_period_end FROM service"'
Reply