forked from ixpantia/lacrmr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
environment_variables.Rmd
151 lines (115 loc) · 5.24 KB
/
environment_variables.Rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
---
title: "lacrmr"
output: rmarkdown::html_vignette
vignette: >
%\VignetteIndexEntry{environment_variables}
%\VignetteEngine{knitr::rmarkdown}
%\VignetteEncoding{UTF-8}
---
```{r, include = FALSE}
knitr::opts_chunk$set(
collapse = TRUE,
comment = "#>"
)
```
```{r setup}
library(lacrmr)
```
# Why using lacrmr?
lacrmr is a package that allows you to connect with your [Less Annoying CRM](https://www.lessannoyingcrm.com/) account and obtain the data of your
customers and contacts.
## Using lacrmr:
The first step is to look for the credentials in order to connect to your
lacrm. When you are logged into your account, go to `settings` > `Programmer API`
Here you will need to create an API Token. When you go through this process
you will obtain two pieces of information:
- **User code**
- **API token**
Please make sure to save this credentials in a secure place. Otherwise anyone
with this credential will be able to check your information through an API.
Then if you go down on the page, you will see other pieces of information as
**User ID'S**, **Pipeline ID** and **Status ID**. This info will be useful in
order to make use of the functions in this package.
# What information can we obtain with lacrmr?
The lacrmr package have four functions:
- `get_pipeline_report()`
- `search_contacts()`
- `get_contact_information()`
- `get_account_information()`
## **`get_pipeline_report()`**
This function returns the data from one specific pipeline that you create
on your CRM. For this you will need to obtain the pipeline id that you want
to work with from R.
The variables to obtain with this function are:
```
[1] "result_contact_id"
[2] "result_user_id"
[3] "result_company_id"
[4] "result_background_info"
[5] "result_birthday"
[6] "result_is_company"
[7] "result_company_name"
[8] "result_industry"
[9] "result_num_employees"
[10] "result_creation_date"
[11] "result_edited_date"
[12] "result_original_google_id"
[13] "result_employer_name"
[14] "result_company_employees"
[15] "result_pipeline_id"
[16] "result_status_id"
[17] "result_priority"
[18] "result_last_note"
[19] "result_start_date"
[20] "result_last_update"
[21] "result_num_updates"
[22] "result_start_status_id"
[23] "result_last_updated_by"
[24] "result_sort_order"
[25] "result_show_in_reports"
[26] "result_pipeline_item_id"
[27] "result_status_name"
[28] "success"
[29] "result_custom_fields_priority"
[30] "result_custom_fields_descripcion_oportunidad"
[31] "result_custom_fields_valor"
```
## **`search_contacts()`**
This function will make you sure about if a contact id exists or not on your
CRM records.
If the contact id you provided to the function does indeed exists, you will
see the message `The search item does exists in the CRM`. If not, the
message will be `There is no such item in the CRM`
## **`get_contact_information()`**
This function will allow you to return the contact information storage in your
CRM. When you use this function with a specific contact id, you will see
the next variables:
```
[1] "contact_contact_id" "contact_user_id"
[3] "contact_company_id" "contact_email"
[5] "contact_phone" "contact_text"
[7] "contact_address_street" "contact_address_city"
[9] "contact_address_state" "contact_address_country"
[11] "contact_address_zip" "contact_address_type"
[13] "contact_address_type_id" "contact_background_info"
[15] "contact_birthday" "contact_is_company"
[17] "contact_company_name" "contact_industry"
[19] "contact_num_employees" "contact_creation_date"
[21] "contact_edited_date" "contact_original_google_id"
[23] "contact_custom_fields" "contact_contact_custom_fields"
```
## **`get_account_information()`**
This function will simply show the information of your account or the account
from which you entered the credentials to obtain the access to lacrm. The
variables will be:
```
[1] "FirstName" "LastName" "Email"
[4] "UserId" "AccountId" "IsOwner"
[7] "IsAdmin" "BlockExports" "Timezone"
[10] "DateUserCreated" "DateAccountCreated" "Success"
```
# Obtaining credentials:
In order to make the package works, you would need to create an .Renviron
file inside your working directory that should contain environment variables
as your api token, user code and pipelineID.
All this information you will find it at lacrm.