View source for Adding or Updating Members

== '''Does a Member Exist?''' ==

<br/>Find out if a specific email address already exists in the site ([[Getting_Site_Information|get a SiteID]]). Send a GET request to the Members endpoint and include the email address in the $filter query string parameter.

==== Sample Request (Using 1234567890 as the SiteID): ====

 GET [http://services.fishbowl.com/api/odata/v1/SITE_ID/Members?$filter=EmailAddress http://services.fishbowl.com/api/odata/v1/SITE_ID/Members?$filter=EmailAddress]
 %20eq%20'johndoe@test.com' HTTP/1.1
 Accept: application/json
 Authorization: Bearer u7kBYz1UhHkoRSc7V4gruBs-4sEpIkFV-F4LGiFMwfGwJNnT_JzNft
 g6_Zm0yWi8P m60iPlmCCHUSwCX5Uru-OJq2jzhbT-E6nAc1OwzghTCmeoo0K69ubDBMFX5hyKlc
 AjA9H3Vs-ZNjNYKarpSO5rA5ubG5-Va5Aigm9mp-Pre-EaGAY_HBdxZi-LBMSQ_mSjyIDPBpLFYP
 BNzK3cu0xGobGsFLxPtDG3urs_4abXZtvxN8wm9rpsgr

==== <br/>Sample Respone When a Member is New (Does not exist): ====

 { 
 "odata.metadata":"[http://services.fishbowl.com/API/odata/v1/1234567890/$metadata#Members http://services.fishbowl.com/API/odata/v1/1234567890/$metadata#Members]",
 "value":[]
 }

==== Sample Respone When a Member Exists in the Database: ====

   { 
 "odata.metadata":"[http://enterprise.qa.fishbowl.com/API/odata/v1/2147483947/ http://services.fishbowl.com/API/odata/v1/2147483947/]
       $metadata#Members",
 "value":[ 
 { 
 "MemberID":"2148166490",
 "SiteID":"2147483947",
 "EmailAddress":"johndoe@test.com",
 "HardBounces":0,
 "SoftBounces":0,
 "Suppressed":false,
 "IsTester":false,
 "CreatedUtc":"2014-11-07T17:13:23.88Z",
 "LastUpdatedUtc":"0001-01-01T05:00:00Z",
 "StringFields":[ 
 { 
 "Name":"FirstName",
 "Value":"John" 
 },
 { 
 "Name":"LastName",
 "Value":"Doe" 
 },
 {
 "Name":"StoreCode",
 "Value":"001" 
 },
 {
 "Name":"InputSource",
 "Value":"Partner" 
 }
 ],
 "BooleanFields":[],
 "Int32Fields":[],
 "Int64Fields":[],
 "DateFields":[ 
 { 
 "Name":"Birthdate",
 "Value":"1999-04-03T04:00:00Z" 
 },
 { 
 "Name":"Anniversary",
 "Value":null 
 },
 { 
 "Name":"JoinDate",
 "Value":"2014-12-04T05:00:00Z" 
 }
 ],
 "DecimalFields":[],
 "Subscriptions":[ 
 {
 "ListID":"2147484225",
 "IsSubscribed":true
 },
 {
 "ListID":"2147485177",
 "IsSubscribed":true
 }
 ],
 "MemberTags":[] 
 } 
 ] 
 }
 

== '''Adding a New Member''' ==

A new member can be created by sending a POST request to the Members endpoint and adding them to the correct list ([[Getting_and_Creating_List|get ListID]]) for the Site ([[Getting_Site_Information|Get a SiteID]]).<br/><br/>'''Note: if you try to create member with an email address that already exists, a 409 error (Conflict) will be returned.'''

==== Sample MERGE (Using SiteID - 1234567890 & ListID - 1122334455): ====

 POST [http://enterprise.qa.fishbowl.com/api/odata/v1/SITE_ID/Members http://services.fishbowl.com/api/odata/v1/1234567890/Members] HTTP/1.1
 Accept: application/json
 Authorization: Bearer u7kBYz1UhHkoRSc7V4gruBs-4sEpIkFV-F4LGiFMwfGwJNnT_JzNft
 g6_Zm0yWi8P m60iPlmCCHUSwCX5Uru-OJq2jzhbT-E6nAc1OwzghTCmeoo0K69ubDBMFX5hyKlc
 AjA9H3Vs-ZNjNYKarpSO5rA5ubG5-Va5Aigm9mp-Pre-EaGAY_HBdxZi-LBMSQ_mSjyIDPBpLFYP
 BNzK3cu0xGobGsFLxPtDG3urs_4abXZtvxN8wm9rpsgr
 Content-Type: application/json; charset=utf-8
 {
 "SiteID":"1234567890",
 "EmailAddress":"johndoe@test.com",
 "SubscriptionsForMember":[
 {
 "ListID":"1122334455",
 "IsSubscribed":true
 }
 ],
 "StringFields":[
 {
 "Name":"FirstName",
 "Value":"John"
 },
 {
 "Name":"LastName",
 "Value":"Doe"
 },
 {
 "Name":"StoreCode",
 "Value":"001"
 },
 {
 "Name":"InputSource",
 "Value":"Partner"
 }
 ],
 "DateFields":[
 {
 "Name":"Birthdate",
 "Value":"1999-04-03T04:00:00Z"
 },
 {
 "Name":"Anniversary",
 "Value":null
 },
 {
 "Name":"JoinDate",
 "Value":"2014-12-04T05:00:00Z"
 }
 ]
 }
 

== '''Updating a Member''' ==

<br/>To update the member record and/or subscribe the member to additional list(s), send a PATCH or MERGE request to the Members endpoint and include the member ID as parameter (Member ID can be obtained from the response).

<br/>The request URL will have the following format: [http://enterprise.qa.fishbowl.com/API/odata/v1/SITE_ID/Members(MEMBER_IDL) http://services.fishbowl.com/API/odata/v1/SITE_ID/Members(MEMBER_IDL)] Note the L following the MemberID, which is used to indicate 64-bit integer, e.g.: (2148166490L)



==== Sample POST (Using SiteID - 1234567890 & ListID - 1122334455) ====

 MERGE [http://services.fishbowl.com/API/odata/v1/1234567890/Members(MEMBER_IDL) http://services.fishbowl.com/API/odata/v1/1234567890/Members(MEMBER_IDL)]
 HTTP/1.1
 Accept: application/json
 Authorization: Bearer u7kBYz1UhHkoRSc7V4gruBs-4sEpIkFV-F4LGiFMwfGwJNnT_JzNft
 g6_Zm0yWi8P m60iPlmCCHUSwCX5Uru-OJq2jzhbT-E6nAc1OwzghTCmeoo0K69ubDBMFX5hyKlc
 AjA9H3Vs-ZNjNYKarpSO5rA5ubG5-Va5Aigm9mp-Pre-EaGAY_HBdxZi-LBMSQ_mSjyIDPBpLFYP
 BNzK3cu0xGobGsFLxPtDG3urs_4abXZtvxN8wm9rpsgr
 Content-Type: application/json; charset=utf-8
 {
 "SiteID":"1234567890",
 "MemberID":"9876543210",
 "EmailAddress":"johndoe@test.com",
 "SubscriptionsForMember":[
 {
 "ListID":"1122334455",
 "IsSubscribed":true         
 }
 ],
 "StringFields":[
 {
 "Name":"FirstName",
 "Value":"John"
 },
 {
 "Name":"LastName",
 "Value":"Doe"
 },
 {
 "Name":"StoreCode",
 "Value":"001"
 }
 ],
 "DateFields":[
 {
 "Name":"Birthdate",
 "Value":"1999-04-03T04:00:00Z"
 },
 {
 "Name":"Anniversary",
 "Value":"2014-2-14T05:00:00Z"
 }
 ]
 }

== '''Dates & Date Conversion''' ==

Dates are stored on Fishbowl database using US Eastern Timezone. &nbsp;However, the Enterprise REST API will convert datetime values to UTC.&nbsp;

&nbsp;If a Get request is issued for an existing member whose JoinDate value is 2/14/2020 12 AM in the database, the JSON returned by the API will be:
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><pre>"DateFields": [

        {

          "Name": "JoinDate",

          "Value": "2020-02-14T05:00:00Z"

        }]</pre>
</div>
To specify a date value when creating or updating a member, the date needs to be converted to UTC first. &nbsp;Do not send a date without specifying timezone as it will be assumed to be UTC.

''Example'':&nbsp;We want to set JoinDate to be 2/14/2020 – make sure to specify the time and timezone offset like in the 2<sup>nd</sup> and 3<sup>rd</sup> examples:

{| border="1" cellspacing="1" cellpadding="1" style="width: 675px;"
|-
| style="width: 177px;" | Value in JSON<br/>
| style="width: 259px;" | DateTime value interpreted by API<br/>
| style="width: 223px;" | Value saved in the database<br/>
|-
| style="width: 177px;" | 2020-02-14<br/>
| style="width: 259px;" | Feb 14, 2020 12 AM UTC<br/>
| style="width: 223px;" | 2020-02-13 19:00:00.000<br/>
|-
| style="width: 177px;" | 2020-02-14T05:00:00Z<br/>
| style="width: 259px;" | Feb 14, 2020 5 AM UTC<br/>
| style="width: 223px;" | 2020-02-14 00:00:00.000<br/>
|-
| style="width: 177px;" | 2020-02-14T00:00:00-05:00<br/>
| style="width: 259px;" | Feb 14, 2020 12 AM EST<br/>
| style="width: 223px;" | 2020-02-14 00:00:00.000<br/><br/>
|}