GetAllOpportunities

Function returns all opportunities

GET https://rest.crmango.com/api/GetAllOpportunities

Authorization

1 Sent in the request headers
Bearer varchar

Auth token

Body data

0 Sent in the request body

This endpoint takes no body parameters

Response

30 HTTP 200

Function returns all opportunities

opp_id integer

Opportunity ID

opp_name varchar

Opportunity name

creation_date timestamp

Date of creation

last_updated timestamp

Date of updated

close_date timestamp

Date of close this opportunity

last_status_date timestamp

Date of last status update

assum_date_of_sale timestamp

Date of assumed sale

company_id integer

Company id

sales_value_ont integer|float

Sales disposable

sales_value_mon integer|float

Sales month

sales_value_quar integer|float

Sales quarterly

sales_value_half integer|float

Sales semiannually

sales_value_annual integer|float

Sales annual

profit_value_ont integer|float

Profit disposable

profit_value_mon integer|float

Profit month

profit_value_quar integer|float

Profit quarterly

profit_value_half integer|float

Profit semiannually

profit_value_annual integer|float

Profit annual

currency_id integer

Currency id

user_id integer

User id

percentage_status integer

Probability of success. 0-100%

status_id integer

Status id

product_id integer

Product id

opportunity_type integer

Opportunity id

lost_reason varchar

Lost opportunity reason

won_reason varchar

Won opportunity reason

note varchar

Note

connected_offer_id integer

Offer id

connected_order_id integer

Order id

own_ varchar

Own columns

Example request

curl --request GET \
  --url 'https://rest.crmango.com/api/GetAllOpportunities' \
  --header 'Authorization: Bearer auth_token'
{
    "code": 200,
    "response": [
        {
            "opp_id": 62,
            "opp_name": "Testovacia ponuka na opport",
            "creation_date": "2023-01-02 18:15:34",
            "last_updated": "2023-01-02 18:15:34",
            "close_date": null,
            "last_status_date": "2023-01-02 18:15:34",
            "assum_date_of_sale": null,
            "company_id": 3538,
            "sales_value_ont": 1.28,
            "sales_value_mon": 0,
            "sales_value_quar": 0,
            "sales_value_half": 0,
            "sales_value_annual": 200,
            "profit_value_ont": 0.7,
            "profit_value_mon": 0,
            "profit_value_quar": 0,
            "profit_value_half": 0,
            "profit_value_annual": 100,
            "currency_id": 100,
            "user_id": 3,
            "percentage_status": 0,
            "status_id": 1,
            "product_id": 13,
            "opportunity_type": 0,
            "lost_reason": null,
            "won_reason": null,
            "note": null,
            "connected_offer_id": 374,
            "connected_order_id": 0,
            "own_Test_text": null,
            "own_Test_dlhy_text": null,
            "own_Poucet_vozidlovych_jednotiek": null,
            "own_test_checkbox": null,
            "own_test_zoznam": null,
            "own_test_datum": null
        },
        {
            "opp_id": 63,
            "opp_name": "Testovacia ponuka na opport",
            "creation_date": "2023-01-02 18:44:40",
            "last_updated": "2023-01-02 18:44:40",
            "close_date": null,
            "last_status_date": "2023-01-02 18:44:40",
            "assum_date_of_sale": "2023-01-12 00:00:00",
            "company_id": 3538,
            "sales_value_ont": 1.28,
            "sales_value_mon": 0,
            "sales_value_quar": 0,
            "sales_value_half": 0,
            "sales_value_annual": 0,
            "profit_value_ont": 0.7,
            "profit_value_mon": 0,
            "profit_value_quar": 0,
            "profit_value_half": 0,
            "profit_value_annual": 0,
            "currency_id": 202,
            "user_id": 3,
            "percentage_status": 0,
            "status_id": 1,
            "product_id": 13,
            "opportunity_type": 2,
            "lost_reason": "",
            "won_reason": "",
            "note": "",
            "connected_offer_id": null,
            "connected_order_id": null,
            "own_Test_text": "",
            "own_Test_dlhy_text": "12",
            "own_Pocet_vozidlovych_jednotiek": 10,
            "own_test_checkbox": 1,
            "own_test_zoznam": "0",
            "own_test_datum": "2023-01-05 00:00:00"
        }
    ]
}