104 results found

1. Get Invoice

   I'm trying to retrieve an invoice via the API with the endpoint /accounts/{accountId}/invoices/{invoiceId} but in the documentation it is impossible to make the call work:
   https://app.swaggerhub.com/apis-docs/WildApricot/wild-apricot_public_api/8.03.0#/Finances.Invoices/GetInvoiceDetails

   The first parameter which should correspond to accountId is replaced by () and in the return example there is only "string".
   If I test the endpoint, the accountId parameter is not sent with my value.

   For information, I tested other API endpoints and they work:
   - /
   - /accounts
   - /accounts/{accountId}
   - /accounts/{accountId}/contacts
   - /accounts/{accountId}/contacts/{contactId}

   So I tested a PHP example provided by Wildapricot:
   https://github.com/WildApricot/ApiSamples/blob/master/PHP/sampleApplication.php
   I replaced the connection values and everything works fine.

   I tested the endpoint /accounts/{accountId}/invoices/{invoiceId}
   and I have a 404 return code which means not found.

   I made a call to the endpoint /accounts/{accountId}/invoices
   and I have a return code 400 which means bad request.
   I added the invoiceId parameter but still the same error.

   Do you need to do anything special to use endpoint invoices?

   Note that in the authorized app, I checked full access.

   I'm trying to retrieve an invoice via the API with the endpoint /accounts/{accountId}/invoices/{invoiceId} but in the documentation it is impossible to make the call work:
   https://app.swaggerhub.com/apis-docs/WildApricot/wild-apricot_public_api/8.03.0#/Finances.Invoices/GetInvoiceDetails

   The first parameter which should correspond to accountId is replaced by () and in the return example there is only "string".
   If I test the endpoint, the accountId parameter is not sent with my value.

   For information, I tested other API endpoints and they work:
   - /
   - /accounts
   - /accounts/{accountId}
   - /accounts/{accountId}/contacts
   - /accounts/{accountId}/contacts/{contactId}

   So I tested a PHP example provided by Wildapricot:
   https://github.com/WildApricot/ApiSamples/blob/master/PHP/sampleApplication.php
   I replaced the connection values and everything works fine.

   … more

   •  

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Resolved  ·  2 comments  ·  API  ·  Delete…  ·  Admin →

2. Support Coupon Code for Membership Application Non-Admin API

   In the Non-Admin API, the "rpc/{accountId}/ApplyForRenewal" call, the API documentation shows that a "Coupon Code" can be submitted as part of the body of the request. The "rpc/{accountId}/applyForMembership" call does not show a "Coupon Code" in the documentation.
   
   Is it supported? If yes, how should the request be formatted? If it is not supported, is there an alternate way to add a discount code to a membership invoice via API?

   I have tried the following JSON body. It successfully creates a pending membership with the correct Level, but the discount code is ignored. (no error, it is just ignored). The code is valid and works if I apply for membership in the user interface.

   {
   "membershipLevelId": 1050822,
   "Coupon Code":"CO100"
   }

   In the Non-Admin API, the "rpc/{accountId}/ApplyForRenewal" call, the API documentation shows that a "Coupon Code" can be submitted as part of the body of the request. The "rpc/{accountId}/applyForMembership" call does not show a "Coupon Code" in the documentation.
   
   Is it supported? If yes, how should the request be formatted? If it is not supported, is there an alternate way to add a discount code to a membership invoice via API?

   I have tried the following JSON body. It successfully creates a pending membership with the correct Level, but the discount code is ignored. (no error, it is just ignored). The… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  API  ·  Delete…  ·  Admin →
   Resolved  ·  AdminKatya Tyukina (Director of Product Management, Wild Apricot by Personify) responded

   CouponCode is available as a parameter for Membership Application and Renewal.

3. auth0

   I have built a sms portal using Laravel + Auth0/Google_SSO + Wild Apricot (read only) API's, which works great. That Auth0 authenticated users against the Google user repository, but now have started building a second Laravel + Auth0 + Wild Apricot (read & write) API's where I want to first be able to use the Auth0 SSO to authenticate against Wild Apricot. I am using their "oauth capable" social login (URL: https://auth0.com/docs/authenticate/identity-providers/social-identity-providers/oauth2 ), which seems to work. I get the WA username/password login screen and it signs in, but there it stops and seems like the token that is issued is either not available or captured and then used in the subsequent API call to get user context/details. I get the following log error in Auth0:

   {
   "date": "2022-04-02T22:00:54.362Z",
   "type": "f",
   "description": "User failed to login",
   "connection": "WildApricot",
   "connectionid": "<connectionid>",
   "clientid": "<clientid>",
   "clientname": "All Applications",
   "ip": "<ipaddress>",
   "useragent": "Firefox 99.0.0 / Mac OS X 10.15.0",
   "details": {
   "body": {},
   "qs": {
   "code": "101dc95bae0c4c66925dcdef4f8ea79c",
   "state": "j91jcYcN0vLvdgCC3oryf34j0SP0plRw"
   },
   "connection": "WildApricot",
   "error": {
   "message": null,
   "oauthError": "invalidrequest",
   "type": "request-error"
   },
   "sessionid": "NQCu9QS4XDgz6glf8K80uKjUyRoqVwnm"
   },
   "hostname": "<outauth0domain>",
   "strategy": "oauth2",
   "strategytype": "social",
   "logid": "90020220402220059406141054250671160826950045098158588002",
   "id": "90020220402220059406141054250671160826950045098158588002",
   "isMobile": false
   }

   .. but if I open a second browser tab I am authenticated and can browse the website.. just not the Auth0 integration works. Presume the next step in that Auth0 chain is to grab the token, issue a WA API request to get the user details and hand that over to Laravel. I am not sure about the details in this process, but trying to dig.

   There is an error in the browser as well, which says the following (see attached picture as well):

   ///
   Bummer! Something failed
   If you are seeing this, it means that your connection didn't work.
   These are the details:
   
   {
   "error": "invalid_request"
   }
   ///

   Would be great to get some help in getting this done. I will also reach out to Auth0 to get some inputs and help as well if possible.

   Thanks in advance!

   /Jorgen

   I have built a sms portal using Laravel + Auth0/Google_SSO + Wild Apricot (read only) API's, which works great. That Auth0 authenticated users against the Google user repository, but now have started building a second Laravel + Auth0 + Wild Apricot (read & write) API's where I want to first be able to use the Auth0 SSO to authenticate against Wild Apricot. I am using their "oauth capable" social login (URL: https://auth0.com/docs/authenticate/identity-providers/social-identity-providers/oauth2 ), which seems to work. I get the WA username/password login screen and it signs in, but there it stops and seems like the token that is issued… more

   •  

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Resolved  ·  1 comment  ·  API  ·  Delete…  ·  Admin →

4. Authentication for the API call to observe the Contact's privacy settings

   We are using the API https://api.wildapricot.org/v2/accounts/\(id)/contacts to get the list of contacts.

   We use User login + password authentication for the API call.

   If we use an admin account for the API authentication we get all fields for each contact, even fields that the contact has marked as "No access" in privacy. If we use a regular user account for the authentication we get immediately an HTTP 403 unauthorized status to even run the query.

   So the question: how do we set up the authentication for this API call so that the query only returns contact fields that the contact has marked privacy as "Members" or "Anybody". For fields marked "No Access" the data should be nil.

   We are using the API https://api.wildapricot.org/v2/accounts/\(id)/contacts to get the list of contacts.

   We use User login + password authentication for the API call.

   If we use an admin account for the API authentication we get all fields for each contact, even fields that the contact has marked as "No access" in privacy. If we use a regular user account for the authentication we get immediately an HTTP 403 unauthorized status to even run the query.

   So the question: how do we set up the authentication for this API call so that the query only returns contact fields that the contact… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Delete…  ·  Admin →
   Resolved  ·  Dmitry Smirnov responded

   If you need access API on behalf of a user, then you should use API endpoints for non-administrative access. They are described here https://gethelp.wildapricot.com/en/categories/145-wild-apricot-member-api

5. export membership data

   I have been reading the doc but I don't see what API call I use to download a variety of member data. I need more than Membership Level.

   I want an API call like the Member List Export, where I can choose the fields.
   I want to export (for all members) member first,last,level,status, and one custom field we have in our database. Prefer output as CSV, but JSON would be fine.
   I need this via the API because I want to automate it to feed into a Access Validation system we have developed, not google docs or Excel, etc.
   I need these automated so it can run once a day.

   Thanks.

   I have been reading the doc but I don't see what API call I use to download a variety of member data. I need more than Membership Level.

   I want an API call like the Member List Export, where I can choose the fields.
   I want to export (for all members) member first,last,level,status, and one custom field we have in our database. Prefer output as CSV, but JSON would be fine.
   I need this via the API because I want to automate it to feed into a Access Validation system we have developed, not google docs or Excel, etc.
   I… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  API  ·  Delete…  ·  Admin →
   Resolved  ·  Dmitry Smirnov responded

   You can receive all contacts data by calling the https://api.wildapricot.org/v2.2/accounts/ACCOUNT_ID/Contacts/ endpoint. As it could be a long query, the call will be executed asynchronically. You will receive the result ID and then you will be able to receive actual results by calling the https://api.wildapricot.org/v2.2/accounts/192743/Contacts/?resultId=RESULT_ID

6. Update User's group participation api V2.2

   I'm trying to update a user's group participation via the put endpoint /accounts/{accountId}/contacts/{contactId}. I'm getting a 200 returned, but the returned model doesn't reflect the attempted updates. Any advice is appreciated. The following is the relevant section of json for the update.

   "FieldValues": [{
   "FieldName": "Group participation",
   "Value": [
   {
   "Id": 559646,
   "Label": "tmpCardGroup"}],
   "SystemCode": "Groups"
   }]

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   5 comments  ·  How to  ·  Delete…  ·  Admin →
   Resolved  ·  Team Mobile responded

   Feel free to comment if your issue remains unresolved

7. Date timezone?

   1. Date timezone - If I get a datetime back from an API call in JSON (e.g. an event start date) in which timezone is that date expressed? I was thinking it would be expressed in UTC but that does not seem to be the case. It appears to be expressed in my current timezone PDT. e.g. if my event in California (PDT) starts at 9:00 am PDT then does the event start time JSON string returned come back as 9:00 am or 4:00 pm? (i.e. expressed in the PDT or UTC time zone)

   The JSON date string in question has not undergone any processing in the app when it's displayed. It's simply retrieved from the JSON data returned by the query (..v1/accounts/{accountid}/events) as a string and printed. (This is Swift iOS code)

   1. Date timezone - If I get a datetime back from an API call in JSON (e.g. an event start date) in which timezone is that date expressed? I was thinking it would be expressed in UTC but that does not seem to be the case. It appears to be expressed in my current timezone PDT. e.g. if my event in California (PDT) starts at 9:00 am PDT then does the event start time JSON string returned come back as 9:00 am or 4:00 pm? (i.e. expressed in the PDT or UTC time zone)

   The JSON date string in question has… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Delete…  ·  Admin →
   Resolved  ·  Dmitry Smirnov responded

   API returns dates in ISO 8601 format. Here is an example:
   “2019-11-15T15:05:39.453-04:00”
   date: 2019-11-15
   time: 15:05:39.453
   UTC offcet: -04:00

   AI uses UTC offset of your organization’s timezone.

8. file attachment API

   Now that WA can save file attachments, can we get an API, similar to /photos that can retrieve the attachment by Id?

   9 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   3 comments  ·  API  ·  Delete…  ·  Admin →
   Resolved  ·  AdminKatya Tyukina (Director of Product Management, Wild Apricot by Personify) responded

   Completed in 2023, see https://gethelp.wildapricot.com/en/articles/2007-public-api-2023-updates

9. How do I connect/view my Wild Apricot database using a third party application?
   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  How to  ·  Delete…  ·  Admin →
   Resolved  ·  Dmitry Smirnov responded

   Wild Apricot does not provide direct access to the database. Please use API instead.

10. Why am I getting 404 error when requesting token? (kotlin/android/retrofit)

    (TEMPLATE)
    POST /auth/token HTTP/1.1
    Host: oauth.wildapricot.org
    Authorization: Basic QVBJS0VZOm85c2U4N3Jnb2l5c29lcjk4MDcwOS0=
    Content-type: application/x-www-form-urlencoded

    granttype=clientcredentials&scope=auto

    (My Attempt)--------------------------------------------------------------------

    object WAApiCallService {
    private const val APIKEY = "xxxxxxxxxxxxxxxxxxxx"
    private const val BASEURL = "https://oauth.wildapricot.org"
    private val AUTH = "Basic" + Base64.encodeToString(APIKEY.toByteArray(), Base64.NOWRAP)
    private const val CONTENT_TYPE = "application/x-www-form-urlencoded"

    private var api:WAApiCall? = null
    
    private fun getWAApi(context: Context) : WAApiCall {
    
        if(api==null){
            val OkHttpClient = OkHttpClient.Builder()
            val logging = HttpLoggingInterceptor()
            logging.level = HttpLoggingInterceptor.Level.BODY
            if(BuildConfig.DEBUG){
                OkHttpClient.addInterceptor(logging)
            }
                    //define and add a cache
            val cacheSize = 5 * 1024 * 1024L // = 5mb cache
            val cache = Cache(context.cacheDir, cacheSize) 
                    //add cache to client
            OkHttpClient.cache(cache)
    
                //add custom interceptor
            OkHttpClient.addInterceptor{chain ->
                //get the outgoing request
                val request = chain.request()
    
               val newRequest = request.newBuilder()
                    .addHeader("Authorization", AUTH)
                    .addHeader("Content-type", CONTENT_TYPE)
                    .build()
                chain.proceed(newRequest)
    
            }
            api = Retrofit.Builder()
                .baseUrl(BASE_URL)
                .addConverterFactory(GsonConverterFactory.create())
                .client(OkHttpClient.build())
                .build()
                .create(WAApiCall::class.java)
        }
        return api!!
    }
    
    fun call(context: Context) =
        getWAApi(context)
    

    }

    (The Call Interface)-------------------------------------------------------
    interface WAApiCall {

    @POST("auth/token HTTP/1.1")
    fun callPost(@Body body:String ): Call<AuthToken>
    

    }

    (RESPONSE DATA CLASS)--------------------------------------------------------
    data class AuthToken(
    @SerializedName("accesstoken")
    var accessToken: String,
    @SerializedName("expiresin")
    var expiresIn: Int,
    @SerializedName("permissions")
    var permissions: List<Permission>,
    @SerializedName("refreshtoken")
    var refreshToken: String,
    @SerializedName("tokentype")
    var tokenType: String
    )

    (FUNCTION IN MAIN ACTIVITY THAT I CALL)-----------------------------------------

    fun testRequest(){
    val call = WAApiCallService.call(this)
    call.callPost("granttype=clientcredentials&scope=auto&obtainrefreshtoken=true")
    .enqueue(object: Callback<AuthToken>{
    override fun onFailure(call: Call<AuthToken>, t: Throwable) {
    Log.i("FAILURE", t.localizedMessage)
    }

            override fun onResponse(call: Call<AuthToken>, response: Response<AuthToken>) {
                Log.i("SUCCESS", "TOKEN = ${response.body()}")
                Log.i("SUCCESS", "${response}")
            }
        })
    

    }

    (THE RESPONSE I GET)-----------------------------------------------------------
    I/SUCCESS: TOKEN = null

    I/SUCCESS: Response{protocol=http/1.1, code=404, message=Not Found, 
      url=https://oauth.wildapricot.org/auth/token%20HTTP/1.1}
    

    (TEMPLATE)
    POST /auth/token HTTP/1.1
    Host: oauth.wildapricot.org
    Authorization: Basic QVBJS0VZOm85c2U4N3Jnb2l5c29lcjk4MDcwOS0=
    Content-type: application/x-www-form-urlencoded

    granttype=clientcredentials&scope=auto

    (My Attempt)--------------------------------------------------------------------

    object WAApiCallService {
    private const val APIKEY = "xxxxxxxxxxxxxxxxxxxx"
    private const val BASEURL = "https://oauth.wildapricot.org"
    private val AUTH = "Basic" + Base64.encodeToString(APIKEY.toByteArray(), Base64.NOWRAP)
    private const val CONTENT_TYPE = "application/x-www-form-urlencoded"

    private var api:WAApiCall? = null
    
    private fun getWAApi(context: Context) : WAApiCall {
    
        if(api==null){
            val OkHttpClient = OkHttpClient.Builder()
            val logging = HttpLoggingInterceptor()
            logging.level = HttpLoggingInterceptor.Level.BODY
            if(BuildConfig.DEBUG){
                OkHttpClient.addInterceptor(logging)
            }
                    //define and add a cache
            val cacheSize = 5 * 1024 * 1024L // = 5mb cache
            val cache = Cache(context.cacheDir, cacheSize)

    … more
    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    API endpoint should be https://oauth.wildapricot.org/auth/token
    but you post to https://oauth.wildapricot.org/auth/token%20HTTP/1.1

11. Change Event AccessLevel from API

    Please provide a way to change Event AccessLevel from API. I clone/create events via programs using API and need to change AccessLevel to Public as final step to enable registration. Thanks!

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Team Mobile responded

    Hello Steve,
    You can change AccessLevel via API.
    As it is written in our documentation (https://app.swaggerhub.com/apis/WildApricot/wild-apricot_public_api/2.1.0#/Events/UpdateEvent), this request body will change AccessLevel to Public:

    {
    “Id”: yourEventID,
    “Details”: {
    “AccessControl”: {
    “AccessLevel”: “Public”
    }
    }
    }

    I hope it helps!

12. Need to build API SSO bridge btw WA and other platform -- any tips?
    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    8 comments  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    Take a look at a sample web app https://github.com/WildApricot/ApiSamples/tree/master/C%23/OAuthClientTestApp

13. Get member first name, last name, email address from id

    I have tried unsuccessfully to get a user first name, last name, email address from the ID.
    Here is what I tried to get the last name:
    https://api.wildapricot.org/v2.1/accounts/12345/contacts?async=false&$filter=$async=false&?$select='Last%20Name'%$filter='Member ID' eq 11111111

    What am I doing wrong?
    Thanks,
    Jay

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    There is a strange mix of parameters and invalid syntax in this example. Please check documentation to find right syntax.

    To get a single contact details by id
    https://api.wildapricot.org/v2.1/accounts/{ACCOUNT_ID}/contacts/{CONTACT_ID}

    As an alternative to writing code you can use out module on Integromat https://www.integromat.com/en/integrations/wild-apricot

14. Cancel Registration API

    We need to be able to cancel registrations via the API. The only option currently is to delete the registration, which is far from ideal since there is no longer any record of the registration in WA, and no way to restore the registration manually.

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    Implemented, https://app.swaggerhub.com/apis-docs/WildApricot/wild-apricot_api_for_non_administrative_access/7.15.0#/Messaging/post_rpc__accountId__CancelEventRegistration

15. How to drive the saggerhub api

    Hi. It appears that I should be able to use swaggerhub to pull data from my WA database with the API, but I can't figure out how to do this because the code in the code window of swagger is 'read only'. I can see that I have to change it so that it points to my WA site, and although I have an option to enter API key to authenticate, there seems no way to change the site. Help appreciated

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Resolved  ·  7 comments  ·  API  ·  Delete…  ·  Admin →

16. Add Group participation to the publicview API ContactsMe model

    I would find it really helpful to include "Group participation" in the ContactMe model of the publicview api (https://app.swaggerhub.com/apis-docs/WildApricot/wild-apricot_api_for_non_administrative_access/1.0.0#).

    For consistency, it could be located in the FieldValues collection. Given that /Sys/Profile shows the group participation to users, this addition seems like it would not introduce any new information for the client.

    My use case is that my 3rd party OAuth app would like to restrict access to content based on the WA group participation in a way that is consistent with the WA site page restrictions.

    Thanks!

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Team Mobile responded

    Hello!
    The GroupParticipation field is included in the contact details endpoint if a logged user has enough rights to see it.

17. API Documentation

    Can someone point me to documentation describing how to get started developing on top of Wild Apricot, including what language to use to interact with the API? I'm a developer but haven't developed on top of a content management system before. I need to be able to display information from the Member table for a specific event.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  How to  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    API specification: https://app.swaggerhub.com/search?query=%20WildApricot

    Help pages: https://gethelp.wildapricot.com/en/categories/32-wild-apricot-apis

    Code samples: https://github.com/WildApricot/ApiSamples

    Instead of writing code you could use Integromat service to implement you custom automation. Here is a link for quick start: https://gethelp.wildapricot.com/en/articles/1653

18. API and custom fields - how to reference them in $select or $filter

    Hi. According to some of the documentation it implies that I can use a custom fields' name to reference it. I can directly reference common fields as a $select parameter, but can only reference other fields using their custom-xxx tag, like this:

    '$select' => 'First name, Last name, Email, custom-8097667,
    custom-8097668, custom-8161502, custom-8097675, custom-8017535'

    The custom field tag does not seem to appear anywhere in Membership fields area of the WA database though so the only way I can find it out is by trawling through json data manually.

    Is there a better way to reference those fields, or to find out their custom-xxx reference (as I've mentioned, I've looked through the WA membership fields in the actual WA site and can see no obvious use of this custom-xxx referencing). The code snip below is part of the json returned on a full dump, and SystemCode is the only place that I can see that references the custom field number:
    json data referencing a custom field:

    [6] => Array
    (
    [FieldName] => Practice Address 1
    [Value] => 40 Test Way
    [SystemCode] => custom-8097667
    )

    Hi. According to some of the documentation it implies that I can use a custom fields' name to reference it. I can directly reference common fields as a $select parameter, but can only reference other fields using their custom-xxx tag, like this:

    '$select' => 'First name, Last name, Email, custom-8097667,
    custom-8097668, custom-8161502, custom-8097675, custom-8017535'

    The custom field tag does not seem to appear anywhere in Membership fields area of the WA database though so the only way I can find it out is by trawling through json data manually.

    Is there a better way to reference those fields, or to… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    see comments

19. Connecting to PowerApps with Swagger

    I've downloaded the Swagger file for administrative access and imported into PowerApps in an attempt to create a custom connector. It asks for several fields (see screen shot in attached file).

    I'm not clear on two of the fields to fill in.

    For Authorization URL, it is showing a default of:

    https://YOUR_ORGANIZATION.wildapricot.com/sys/login/OAuthLogin

    I'm not sure what I should replace YOUR_ORGANIZATION with.

    It is also requesting a Refresh URL and I don't know what to put in there.

    Any help would be appreciated. A documented PowerApps connector would be of general use to the WA community and I'd be happy to document the process if I can get it working.

    • gurujeet

    I've downloaded the Swagger file for administrative access and imported into PowerApps in an attempt to create a custom connector. It asks for several fields (see screen shot in attached file).

    I'm not clear on two of the fields to fill in.

    For Authorization URL, it is showing a default of:

    https://YOUR_ORGANIZATION.wildapricot.com/sys/login/OAuthLogin

    I'm not sure what I should replace YOUR_ORGANIZATION with.

    It is also requesting a Refresh URL and I don't know what to put in there.

    Any help would be appreciated. A documented PowerApps connector would be of general use to the WA community and I'd be happy to… more

    •  

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Resolved  ·  5 comments  ·  API  ·  Delete…  ·  Admin →

20. GET /accounts/{accountId}/events

    The swagger docs do not really show how to add the parameters to the HTTP Get request (e.g., $filter). For example, how do I format the request to get all events that have the substring "XYZ" in a Tags field?
    Also what is the syntax of the "TextIndex, Supported operations: substringof." parameter? You have all these good parameters in the Swagger site, but no real examples of how to use the syntax. Are we supposed to guess? Help me out here please. Thanks.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    Resolved  ·  Dmitry Smirnov responded

    As described in swagger, $filter parameter should be passed as a query string parameter.

    It is not possible to look for substrings in tags.

    Here is a good examples of using different kinds of comparison operators: https://gethelp.wildapricot.com/en/articles/499 find ‘Relational operators’ section.