alt text

Navision API

How to use this (AKA README.md)

API REST Return customer's information from the billing platform

"company" Options: qdqmedia and optimiza

  1. Customer's Ledger entrys $ curl http://localhost:5000/api/v1/<company>/customer_ledger_entry/<customer_id>/

    • Returns information of the customer ledger entry.

    • Example: http://apinavision.tsurudev.qdqmedia.com/api/v1/qdqmedia/customer_ledger_entry/6050524/

      • Result:

        { "ledger entry": [ { "N_efecto": "", "Importe_pendiente_DL": -129.62, "Pendiente": 1, "Importe_DL": -228.69, "Descripcion": "Anticipo contrato 612023972067", "Fecha_impagado": "1753-01-01", "Fecha_sistema": "2017-04-07", "Cod_jefe_vtas": "2327", "Cod_forma_pago": "RD", "Id_usuario": "AVALERO", "Canal": "Y", "Cod_origen": "DIARECOBRO", "Fecha_vto": "2017-04-07", "Fecha_registro": "2017-04-07", "Estado_documento": "", "Cod_vendedor": "4695", "N_documento": "V00020/17", "N_contrato": "612023972067", "Tipo_documento": "Pago", "Cod_cliente_navision": "60505240", "Motivo_devolucion": "" }, { "N_efecto": "", "Importe_pendiente_DL": -48.40, "Pendiente": 1, "Importe_DL": -48.40, "Descripcion": "MARINA TERESA GRAPSA", "Fecha_impagado": "1753-01-01", "Fecha_sistema": "2017-04-12", "Cod_jefe_vtas": "2327", "Cod_forma_pago": "RD", "Id_usuario": "AVALERO", "Canal": "Y", "Cod_origen": "DIARECOBRO", "Fecha_vto": "2017-04-12", "Fecha_registro": "2017-04-12", "Estado_documento": "", "Cod_vendedor": "4695", "N_documento": "V00020/17", "N_contrato": "612023972067", "Tipo_documento": "Pago", "Cod_cliente_navision": "60505240", "Motivo_devolucion": "" }, { "N_efecto": "", "Importe_pendiente_DL": 0.00, "Pendiente": 0, "Importe_DL": -99.07, "Descripcion": "Convertir factura 2017063731 en efectos", "Fecha_impagado": "1753-01-01", "Fecha_sistema": "2017-04-12", "Cod_jefe_vtas": "2327", "Cod_forma_pago": "RD", "Id_usuario": "MANGONZALEZ", "Canal": "Y", "Cod_origen": "VENTAS", "Fecha_vto": "2017-04-16", "Fecha_registro": "2017-04-16", "Estado_documento": "", "Cod_vendedor": "4695", "N_documento": "2017063731", "N_contrato": "612023972067", "Tipo_documento": "", "Cod_cliente_navision": "60505240", "Motivo_devolucion": "" }, { "N_efecto": "", "Importe_pendiente_DL": 0.00, "Pendiente": 0, "Importe_DL": 99.07, "Descripcion": "Factura FCST228281", "Fecha_impagado": "1753-01-01", "Fecha_sistema": "2017-04-12", "Cod_jefe_vtas": "2327", "Cod_forma_pago": "RD", "Id_usuario": "MANGONZALEZ", "Canal": "Y", "Cod_origen": "VENTAS", "Fecha_vto": "2017-04-20", "Fecha_registro": "2017-04-16", "Estado_documento": "", "Cod_vendedor": "4695", "N_documento": "2017063731", "N_contrato": "612023972067", "Tipo_documento": "Factura", "Cod_cliente_navision": "60505240", "Motivo_devolucion": "" }, { "N_efecto": "1", "Importe_pendiente_DL": 0.00, "Pendiente": 0, "Importe_DL": 99.07, "Descripcion": "Efecto 2017063731/1", "Fecha_impagado": "1753-01-01", "Fecha_sistema": "2017-04-12", "Cod_jefe_vtas": "2327", "Cod_forma_pago": "RD", "Id_usuario": "MANGONZALEZ", "Canal": "Y", "Cod_origen": "VENTAS", "Fecha_vto": "2017-04-20", "Fecha_registro": "2017-04-16", "Estado_documento": "Pagado", "Cod_vendedor": "4695", "N_documento": "2017063731", "N_contrato": "612023972067", "Tipo_documento": "Efecto", "Cod_cliente_navision": "60505240", "Motivo_devolucion": "" } ] }

  2. Customer's unpaid information $ curl http://localhost:5000/api/v1/<company>/customer_delinquent/<customer_id>/

    • Returns information of the customer for siebel recovering flow.

    • Example: http://apinavision.tsurudev.qdqmedia.com/api/v1/qdqmedia/customer_delinquent/5546219/

      • Result:

        { "Delinquent": [ { "DelinquentFirstDate": "2016-07-11", "DelinquentLastDate": "2017-04-10", "EnterpriseCode": "5546219", "DelinquentBills": "2016113861;2016152146;2016171103;2016189917;2016208569;2017007326;2017043616;2017061594", "DelinquentAmount": 1228.72 } ] }

  3. Customer's debt interests

    curl http://localhost:5000/api/v1/<company>/customer_interests/<customer_id>/

    • Returns information of the customer's debt interests for siebel recovering flow.

    • Example: http://apinavision.tsurudev.qdqmedia.com/api/v1/qdqmedia/customer_interests/1130894/

      • Result:

        { "customer": "1130894", "amounts": { "amount_debt": 1229.36, "amount_interests": 222.99, "amount_total": 1452.35 } }

API POST Navision change customer's information

QDQ Media

  1. Send legal letter

    curl -d '{"company":"qdqmedia", "customer":"9999999", "user": "ARUIZ" }' -H "Content-Type: application/json" -X POST http://localhost:5000/api/v1/legal_customer/

    • Parameters:
      • company: qdqmedia
      • customer: Customer's code of CRM
      • user: Recovery agent's login username

OPTIMIZACLICK

  1. Customer legal step

    curl -d '{"company":"optimiza", "customer":"9999999", "user": "ARUIZ" }' -H "Content-Type: application/json" -X POST http://localhost:5000/api/v1/legal_customer/

    • Parameters:
      • company: optimiza
      • customer: Customer's code of CRM
      • user: Recovery agent's login username

OTHER API FUNCTIONS

GET Customer paid receipt

$ curl http://localhost:5000/api/v1/customer_receipt/qdqmedia/<customer>/ - Parameters: - customer: Customer's code of CRM