Enterprise Sales Management
jmember_upload API
Upload a CSV file with new subscribers or locations.
This API is used with the UploadMembers Vlocity Integration Procedure (VIP) to upload a file with subscriber and location details to be inserted or updated.
HTTP Method
POST
Sample Insert Request Body
1{
2 "QuoteId__c": "0Q05w000001sayRCAQ",
3 "members": [{
4 "StreetAddress__c": "123 Main St",
5 "Address1__c": "Suite 415",
6 "City__c": "San Francisco",
7 "State__c": "CA",
8 "PostalCode__c": "94102",
9 "Country__c": "USA",
10 "Title__c": "VP",
11 "FirstName__c": "Mary",
12 "LastName__c": "Sommer",
13 "Email__c": "msommer@test.com",
14 "MemberType__c": "Location",
15 "MSISDN__c": "1234564567",
16 "Id": ""
17 },
18 {
19 "StreetAddress__c": "1480 SantaClara St",
20 "Address1__c": "Suite 415",
21 "City__c": "Santa Clara",
22 "State__c": "CA",
23 "PostalCode__c": "95050",
24 "Country__c": "USA",
25 "Title__c": "EVP",
26 "FirstName__c": "Tom",
27 "LastName__c": "Hanks",
28 "Email__c": "thanks@test.com",
29 "MemberType__c": "Location",
30 "MSISDN__c": "123456489",
31 "Id": ""
32 }]
33}Sample Update Request Body
1{
2 "QuoteId__c": "0Q05w000001sayRCAQ",
3 "members": [{
4 "StreetAddress__c": "123 Main St",
5 "Address1__c": "Suite 415",
6 "City__c": "San Francisco",
7 "State__c": "CA",
8 "PostalCode__c": "94102",
9 "Country__c": "USA",
10 "Title__c": "VP",
11 "FirstName__c": "Mary",
12 "LastName__c": "Sommer",
13 "Email__c": "msommer@test.com",
14 "MemberType__c": "Location",
15 "MSISDN__c": "1234564567",
16 "Id": "a5X5w000000KWkc"
17 },
18 {
19 "StreetAddress__c": "1480 SantaClara St",
20 "Address1__c": "Suite 415",
21 "City__c": "Santa Clara",
22 "State__c": "CA",
23 "PostalCode__c": "95050",
24 "Country__c": "USA",
25 "Title__c": "EVP",
26 "FirstName__c": "Tom",
27 "LastName__c": "Hanks",
28 "Email__c": "thanks@test.com",
29 "MemberType__c": "Location",
30 "MSISDN__c": "123456489",
31 "Id": "a5X5w000000KWkc"
32 }]
33}Response
1{
2 "Members": [{
3 "UpsertSuccess": true,
4 "Id": "a5X5w000002KqC9EAK",
5 "QuoteId__c": "0Q05w000001sayRCAQ",
6 "Title__c": "VP",
7 "Address1__c": "Suite 415",
8 "Name": "Mary Sommer",
9 "MemberType__c": "Location",
10 "StreetAddress__c": "123 Main St",
11 "State__c": "CA",
12 "PostalCode__c": "94102",
13 "MSISDN__c": "1234564567",
14 "LastName__c": "Sommer",
15 "FirstName__c": "Mary",
16 "Email__c": "msommer@test.com",
17 "Country__c": "USA",
18 "City__c": "San Francisco"
19 },
20 {
21 "UpsertSuccess": true,
22 "Id": "a5X5w000002KqCAEA0",
23 "QuoteId__c": "0Q05w000001sayRCAQ",
24 "Title__c": "EVP",
25 "Address1__c": "Suite 415",
26 "Name": "Tom Hanks",
27 "MemberType__c": "Location",
28 "StreetAddress__c": "1480 SantaClara St",
29 "State__c": "CA",
30 "PostalCode__c": "95050",
31 "MSISDN__c": "123456489",
32 "LastName__c": "Hanks",
33 "FirstName__c": "Tom",
34 "Email__c": "thanks@test.com",
35 "Country__c": "USA",
36 "City__c": "Santa Clara"
37 }]
38}