noi-techpark / it.bz.noi.community

NOI Community App for the Web
GNU General Public License v3.0
0 stars 1 forks source link

As a NOI App content Editor I want to show the data about Contacts with NOI community tag #17

Closed sseppi closed 2 years ago

sseppi commented 2 years ago

Priority: medium Deadline: 28/02/2022

As NOI App content manager I need to get from the CRM the data of the Contacts with the following functionalities:

toburger commented 2 years ago

The API is secured and only accessible after authenticating against the NOI Auth Server.

You can query the desired fields with the following URL: https://api.community.noi.testingmachine.eu/contacts?$top=50&$select=emailaddress1,firstname,lastname

This returns 50 contacts with the email, firstname and lastname (I couldn't find an account name field):

{
    "@odata.context": "https://noitest.crm4.dynamics.com/api/data/v9.2/$metadata#contacts(emailaddress1,firstname,lastname)",
    "value": [
        {
            "@odata.etag": "W/\"60647670\"",
            "emailaddress1": "commerciale@5pm.it",
            "firstname": "Dominique",
            "lastname": "DelGenovese",
            "contactid": "a41713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"34661649\"",
            "emailaddress1": null,
            "firstname": "Giuseppe",
            "lastname": "Cazzulani",
            "contactid": "a61713e3-99a3-e911-a821-000d3a289705"
        },
...
        {
            "@odata.etag": "W/\"34661618\"",
            "emailaddress1": "Giorgio.Caldera@alupress.com",
            "firstname": "Giorgio",
            "lastname": "Caldera",
            "contactid": "b61713e3-99a3-e911-a821-000d3a289705"
        }
    ]
}

To filter against NOI Community I need more information about the record structure, because I can't find any field with such a reference. How is this information stored in Dynamics 365? When I know where this information is stored I can provide the correct filter.

I don't think caching is necessary, as the information can be retrieved in under a second when you provide the correct data. Bear in mind that when not providing any limit or field selection the dataset contains up to 5.000 entries with all the fields! But this can be controlled by the app itself so it can query for the data necessary only.

sseppi commented 2 years ago

@toburger can you share with us a JSON containing all information fro one contact so I can have a look to that file and identify the right field.

RudiThoeni commented 2 years ago

here the structure for a contact

{
            "@odata.etag": "W/\"6064760070\"",
            "customertypecode": 1,
            "donotbulkpostalmail": false,
            "mobilephone": "456789",
            "merged": false,
            "gendercode": 1,
            "territorycode": 1,
            "emailaddress1": "test@test.it",
            "haschildrencode": 1,
            "exchangerate": 1.0000000000,
            "preferredappointmenttimecode": 1,
            "msdyn_orgchangestatus": 0,
            "isbackofficecustomer": false,
            "modifiedon": "2021-06-29T14:09:01Z",
            "_owninguser_value": "4d70eadsf-fa81-e911-a817-000d3a43d4be",
            "importsequencenumber": 6,
            "lastname": "Test",
            "marketingonly": false,
            "donotphone": false,
            "preferredcontactmethodcode": 1,
            "educationcode": 1,
            "_ownerid_value": "4d70ebf4-faasd81-e911-a817-000d3a43d4be",
            "new_contactcat_techtransfergreen": "100034500040",
            "customersizecode": 1,
            "firstname": "Testfirstname",
            "donotpostalmail": false,
            "yomifullname": "Testfullname",
            "address2_addresstypecode": 1,
            "donotemail": false,
            "address2_shippingmethodcode": 1,
            "fullname": "Testfullname",
            "address1_addressid": "2bdef026-6d0f-4c25-a34c-299e6496d6f9",
            "msdyn_gdproptout": false,
            "address2_freighttermscode": 1,
            "statuscode": 1,
            "createdon": "2019-07-11T05:08:48Z",
            "noi_technologyautomotiveautomation": "181640000",
            "donotsendmm": false,
            "donotfax": false,
            "leadsourcecode": 1,
            "versionnumber": 60647670,
            "creditonhold": false,
            "noi_technologydigitaltechnologies": "181640000",
            "telephone1": "0445 560528",
            "_transactioncurrencyid_value": "e9906771-0380-e911-a97c-000d3a45ddd6",
            "address3_addressid": "fdde4806-14a7-45c0-ba1e-59aed8f4cfa6",
            "donotbulkemail": false,
            "_modifiedby_value": "5bece766-0ef1-ea11-a815-000d3a4aa70c",
            "followemail": true,
            "shippingmethodcode": 1,
            "_createdby_value": "13371635-371b-44e5-8498-c8bac80ad42b",
            "noi_addressfromaccount": false,
            "new_preferredlanguage": 100000002,
            "_parentcustomerid_value": "45fbc21a-10a3-e911-a821-000d3a289705",
            "contactid": "a41713e3-99a3-e911-a821-000d3a289705",
            "participatesinworkflow": false,
            "statecode": 0,
            "_owningbusinessunit_value": "efb32a7f-6b8c-e911-a81b-000d3a43d098",
            "address2_addressid": "c01df016-cd11-4276-877e-b644261cce87",
            "telephone3": null,
            "businesscardattributes": null,
            "address1_shippingmethodcode": null,
            "new_contactcat_techtransferaaa": null,
            "familystatuscode": null,
            "_defaultpricelevelid_value": null,
            "adx_profilealertinstructions": null,
            "_preferredequipmentid_value": null,
            "nickname": null,
            "address1_freighttermscode": null,
            "new_contactcat_techtransferfood": null,
            "address3_upszone": null,
            "annualincome_base": null,
            "msgdpr_gdprischild": null,
            "anniversary": null,
            "address1_upszone": null,
            "new_contactcat_facilitymanagement": null,
            "websiteurl": null,
            "adx_profilelastactivity": null,
            "_slainvokedid_value": null,
            "address2_city": null,
            "noi_market": null,
            "address1_postofficebox": null,
            "new_placeofbirth": null,
            "address3_longitude": null,
            "preferredappointmentdaycode": null,
            "utcconversiontimezonecode": null,
            "overriddencreatedon": null,
            "noi_makerspace": null,
            "aging90": null,
            "stageid": null,
            "address3_primarycontactname": null,
            "_msdyncrm_customerjourneyid_value": null,
            "address1_latitude": null,
            "address1_utcoffset": null,
            "home2": null,
            "adx_createdbyipaddress": null,
            "noi_edblastupdate": null,
            "yomifirstname": null,
            "_masterid_value": null,
            "address3_shippingmethodcode": null,
            "lastonholdtime": null,
            "noi_contactcat_placepresscommunity": null,
            "new_contactcat_techtransferdigital": null,
            "address3_stateorprovince": null,
            "address2_fax": null,
            "_msdyncrm_emailid_value": null,
            "address3_telephone3": null,
            "address3_telephone2": null,
            "address3_telephone1": null,
            "msdyn_portaltermsagreementdate": null,
            "noi_expertdbsurveylink": null,
            "adx_identity_emailaddress1confirmed": null,
            "governmentid": null,
            "new_contacttaxnumber": null,
            "address2_line1": null,
            "address1_telephone3": null,
            "address1_telephone2": null,
            "address1_telephone1": null,
            "_msdyncrm_marketingformid_value": null,
            "address2_postofficebox": null,
            "emailaddress2": null,
            "ftpsiteurl": null,
            "emailaddress3": null,
            "processid": null,
            "address2_latitude": null,
            "address2_composite": null,
            "adx_confirmremovepassword": null,
            "traversedpath": null,
            "address1_city": null,
            "spousesname": null,
            "address3_name": null,
            "new_contactcat_innovaitonmanagement": null,
            "address3_postofficebox": null,
            "adx_identity_securitystamp": null,
            "address2_line2": null,
            "adx_publicprofilecopy": null,
            "aging30_base": null,
            "teamsfollowed": null,
            "adx_identity_username": null,
            "address1_addresstypecode": null,
            "managerphone": null,
            "address2_stateorprovince": null,
            "_msdyncrm_segmentmemberid_value": null,
            "address2_postalcode": null,
            "_msa_managingpartnerid_value": null,
            "adx_organizationname": null,
            "address1_composite": null,
            "entityimage_url": null,
            "msdyn_isminorwithparentalconsent": null,
            "aging60": null,
            "managername": null,
            "address3_postalcode": null,
            "adx_identity_accessfailedcount": null,
            "jobtitle": null,
            "timezoneruleversionnumber": null,
            "adx_profilealertdate": null,
            "address3_utcoffset": null,
            "address2_telephone3": null,
            "address2_telephone2": null,
            "address2_telephone1": null,
            "numberofchildren": null,
            "address2_upszone": null,
            "address1_postalcode": null,
            "_owningteam_value": null,
            "_msdyncrm_contactid_value": null,
            "address2_line3": null,
            "timespentbymeonemailandmeetings": null,
            "department": null,
            "address1_country": null,
            "businesscard": null,
            "adx_identity_newpassword": null,
            "new_doublelanguagecommunications": null,
            "address2_longitude": null,
            "suffix": null,
            "_modifiedonbehalfby_value": null,
            "creditlimit": null,
            "address1_line2": null,
            "paymenttermscode": null,
            "address1_county": null,
            "_msgdpr_gdprparentid_value": null,
            "adx_identity_twofactorenabled": null,
            "_preferredsystemuserid_value": null,
            "assistantname": null,
            "address1_fax": null,
            "accountrolecode": null,
            "adx_identity_passwordhash": null,
            "_createdonbehalfby_value": null,
            "_noi_surveycontactid_value": null,
            "annualincome": null,
            "_accountid_value": null,
            "_adx_preferredlanguageid_value": null,
            "adx_identity_lockoutenddate": null,
            "address2_name": null,
            "creditlimit_base": null,
            "msdyncrm_rememberme": null,
            "business2": null,
            "address2_utcoffset": null,
            "_modifiedbyexternalparty_value": null,
            "address3_composite": null,
            "_originatingleadid_value": null,
            "adx_modifiedbyusername": null,
            "_msdyncrm_marketingpageid_value": null,
            "_parent_contactid_value": null,
            "_preferredserviceid_value": null,
            "_slaid_value": null,
            "adx_identity_lockoutenabled": null,
            "fax": null,
            "address1_line1": null,
            "childrensnames": null,
            "address2_county": null,
            "adx_profileisanonymous": null,
            "address3_city": null,
            "adx_portalinvitationurl": null,
            "adx_portalinvitationcode": null,
            "aging30": null,
            "externaluseridentifier": null,
            "adx_timezone": null,
            "address1_line3": null,
            "_parentcontactid_value": null,
            "new_contactcat_sales": null,
            "new_contactcat2_techtransferfood": null,
            "msdyn_isminor": null,
            "_msevtmgt_originatingeventid_value": null,
            "assistantphone": null,
            "address1_stateorprovince": null,
            "birthdate": null,
            "adx_profilealert": null,
            "noi_linkedinprofile": null,
            "msevtmgt_aadobjectid": null,
            "address3_addresstypecode": null,
            "_createdbyexternalparty_value": null,
            "onholdtime": null,
            "msdyncrm_insights_placeholder": null,
            "adx_identity_logonenabled": null,
            "_msevtmgt_contactid_value": null,
            "entityimage_timestamp": null,
            "address3_county": null,
            "adx_identity_mobilephoneconfirmed": null,
            "employeeid": null,
            "subscriptionid": null,
            "entityimageid": null,
            "company": null,
            "callback": null,
            "lastusedincampaign": null,
            "address3_line3": null,
            "msdyn_disablewebtracking": null,
            "msgdpr_donottrack": null,
            "adx_profilemodifiedon": null,
            "new_contactcat_eufunding": null,
            "adx_createdbyusername": null,
            "telephone2": null,
            "address3_freighttermscode": null,
            "yomilastname": null,
            "address3_fax": null,
            "description": null,
            "address3_line1": null,
            "adx_identity_locallogindisabled": null,
            "adx_identity_lastsuccessfullogin": null,
            "address3_line2": null,
            "yomimiddlename": null,
            "msgdpr_gdprconsent": null,
            "new_contactcat_brandandplace": null,
            "new_masksize": null,
            "noi_consultancy": null,
            "aging90_base": null,
            "noi_technologyfoodtechnologies": null,
            "adx_modifiedbyipaddress": null,
            "address1_name": null,
            "_msgdpr_consentchangesourceformid_value": null,
            "address1_primarycontactname": null,
            "address1_longitude": null,
            "new_contactcat_incubator": null,
            "middlename": null,
            "address2_primarycontactname": null,
            "entityimage": null,
            "new_contactcat_labsperformace": null,
            "address3_latitude": null,
            "salutation": null,
            "aging60_base": null,
            "pager": null,
            "noi_technologygreentechnology": null,
            "address3_country": null,
            "address2_country": null
        }
sseppi commented 2 years ago

@toburger I think that the field is:

"noi_contactcat_placepresscommunity": null

The tag should include a list of tags and the one we are looking for should be 0. NOI-Community

toburger commented 2 years ago

Ah perfect! Only problem is that the field is always null:

https://api.community.noi.testingmachine.eu/contacts?$top=10&$filter=noi_contactcat_placepresscommunity+ne+null (reads as: give me the first ten contacts where the noi_contactcat_placepresscommunity not equals null)

Result

{
    "@odata.context": "https://noitest.crm4.dynamics.com/api/data/v9.2/$metadata#contacts",
    "value": []
}
toburger commented 2 years ago

Any news on this? The field noi_contactcat_placepresscommunity is still null for all data returned by the CRM.

sseppi commented 2 years ago

@toburger Just to be sure, are you taking the data from the production or testing CRM?

As soon as you let me know I will ask to Würth Phoenix for more information about that

toburger commented 2 years ago

I'm not sure, because the environment variables for the production service are provided by NOI (using the following keys). The default setting is https://noitest.crm4.dynamics.com/api/data/v9.2. From the domain name it looks like it is using the test database. Maybe @RudiThoeni knows more about the production configuration.

RudiThoeni commented 2 years ago

Hi i checked and there is only a dev deployment which points to SERVICE_URL=https://noitest.crm4.dynamics.com/api/data/v9.2 We have to setup the prod deployment...... But therefore we need all infos from würth phönix and their prod CRM has to be configured like the test version serviceurl, tenant_id, client_id, client_secret

RudiThoeni commented 2 years ago

now i saw in the email from würth phönix (07.02 from Fabrizio della corte) that all keys are the same (tenant_it, client_id, client_secret) only the url differs.... (https://noi.crm4.dynamics.com) @sseppi What should i do, change the url for the test deployment or set up a prod deployment?

sseppi commented 2 years ago

Hi @toburger and @RudiThoeni I asked our communication to tag some contact and account also in the testing environment of the CRM. So I would suggest that we test it in the testing environment, after they put the right tag also there and then, once the test is successful, go on production.

toburger commented 2 years ago

To anticipate I have done some testing on the production CRM API and there the noi_contactcat_placepresscommunity is set.

The noi_contactcat_placepresscommunity contains a list of IDs like this: "181640000,181640003" So we need the right CRM id for the mapping to 0. NOI-Community


To filter by a specific id on a "multi select pick list" a special filter is necessary which I've found in the following documentation.

The following request gets the first 50 contacts that contains the ID 181640000 in the noi_contactcat_placepresscommunity field from the production CRM API.

https://noi.crm4.dynamics.com/api/data/v9.2/contacts?%24filter=Microsoft.Dynamics.CRM.ContainValues(PropertyName%3D%40p1,PropertyValues%3D%40p2)&%40p1='noi_contactcat_placepresscommunity'&%40p2=%5B'181640000'%5D&%24top=50&%24select=emailaddress1,firstname,lastname

{
    "@odata.context": "https://noi.crm4.dynamics.com/api/data/v9.2/$metadata#contacts(emailaddress1,firstname,lastname)",
    "value": [
        {
            "@odata.etag": "W/\"152523145\"",
            "emailaddress1": "carlo.nainer@fraunhofer.it",
            "firstname": "Carlo",
            "lastname": "Nainer",
            "contactid": "8d8127c4-3162-eb11-a812-000d3a207473"
        },
        {
            "@odata.etag": "W/\"152523192\"",
            "emailaddress1": "luca.dallasta@fraunhofer.it",
            "firstname": "Luca",
            "lastname": "Dall'Asta",
            "contactid": "f6a788b0-4362-eb11-a812-000d3a207473"
        },
        {
            "@odata.etag": "W/\"152523184\"",
            "emailaddress1": "giada.malacarne@fraunhofer.it",
            "firstname": "Giada",
            "lastname": "Malacarne",
            "contactid": "39e10954-e25f-eb11-a812-000d3a207e17"
        },
        {
            "@odata.etag": "W/\"110484394\"",
            "emailaddress1": "s.canali@sheractive.com",
            "firstname": "Sara",
            "lastname": "Canali",
            "contactid": "19015da2-40f4-eb11-94ef-000d3a226b93"
        },
        {
            "@odata.etag": "W/\"99385564\"",
            "emailaddress1": "f.ausserer@noi.bz.it",
            "firstname": "Francesca",
            "lastname": "Ausserer Wieser",
            "contactid": "30d43cfa-ebf5-eb11-94ef-000d3a226be2"
        },
        {
            "@odata.etag": "W/\"167035801\"",
            "emailaddress1": "c.cont@noi.bz.it",
            "firstname": "Christian",
            "lastname": "Cont",
            "contactid": "9db5762b-f0f5-eb11-94ef-000d3a226be2"
        },
        {
            "@odata.etag": "W/\"129641265\"",
            "emailaddress1": "diego.calvanese@ontopic.ai",
            "firstname": "Diego",
            "lastname": "Calvanese",
            "contactid": "1876fd9c-93c7-eb11-bacc-000d3a26e1eb"
        },
        {
            "@odata.etag": "W/\"199936438\"",
            "emailaddress1": "milan.fanck@r3gis.com",
            "firstname": "Milan",
            "lastname": "Fanck",
            "contactid": "1f0f4053-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"199936539\"",
            "emailaddress1": "valentina.polo@r3gis.com",
            "firstname": "Valentina",
            "lastname": "Polo",
            "contactid": "d1292d6b-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"199936653\"",
            "emailaddress1": "gerhard.sulzberger@r3gis.com",
            "firstname": "Gerhard",
            "lastname": "Sulzberger",
            "contactid": "767a1583-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"199936919\"",
            "emailaddress1": "alejandro.zarate@r3gis.com",
            "firstname": "Alejandro",
            "lastname": "Zarate",
            "contactid": "3c0302a1-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"199937742\"",
            "emailaddress1": "giacomo.turini@r3gis.com",
            "firstname": "Giacomo",
            "lastname": "Turini",
            "contactid": "df42f6b8-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"200329623\"",
            "emailaddress1": "roberto.mendicino@eurac.edu",
            "firstname": "Roberto",
            "lastname": "Mendicino",
            "contactid": "fcdfd688-9890-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"164210651\"",
            "emailaddress1": "marco.castagna@eurac.edu",
            "firstname": "Marco",
            "lastname": "Castagna",
            "contactid": "aa1713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152520412\"",
            "emailaddress1": "matteo.delbuono@eurac.edu",
            "firstname": "Matteo",
            "lastname": "Del Buono",
            "contactid": "ac1713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152520685\"",
            "emailaddress1": "roberto.fedrizzi@eurac.edu",
            "firstname": "Roberto",
            "lastname": "Fedrizzi",
            "contactid": "ae1713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152520690\"",
            "emailaddress1": "roberto.lollini@eurac.edu",
            "firstname": "Roberto",
            "lastname": "Lollini",
            "contactid": "b01713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152521469\"",
            "emailaddress1": "wolfram.sparber@eurac.edu",
            "firstname": "Wolfram",
            "lastname": "Sparber",
            "contactid": "b21713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152475665\"",
            "emailaddress1": "m.niederbacher@bts-biogas.com",
            "firstname": "Michael",
            "lastname": "Niederbacher",
            "contactid": "bc1713e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152600377\"",
            "emailaddress1": "m.benetti@veil-energy.eu",
            "firstname": "Marianna",
            "lastname": "Benetti",
            "contactid": "521813e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152600369\"",
            "emailaddress1": "k.kress@veil-energy.eu",
            "firstname": "Klaus",
            "lastname": "Kress",
            "contactid": "541813e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152522455\"",
            "emailaddress1": "ulrich.klammsteiner@klimahausagentur.it",
            "firstname": "Ulrich",
            "lastname": "Klammsteiner",
            "contactid": "621813e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"166536005\"",
            "emailaddress1": "marco.bezzi@bluetentacles.com",
            "firstname": "Marco",
            "lastname": "Bezzi",
            "contactid": "b81813e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"169962306\"",
            "emailaddress1": "miriam.benedetti@eurac.edu",
            "firstname": "Miriam",
            "lastname": "Benedetti",
            "contactid": "301913e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152598885\"",
            "emailaddress1": "nicola.baraldi@sauberservizi.it",
            "firstname": "Nicola",
            "lastname": "Baraldi",
            "contactid": "6a1913e3-99a3-e911-a821-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152468876\"",
            "emailaddress1": "carlo.pellegrini@bluetentacles.com",
            "firstname": "Carlo ",
            "lastname": "Pellegrini",
            "contactid": "0dd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152469205\"",
            "emailaddress1": "pisoni.silvano@gmail.com",
            "firstname": "Silvano",
            "lastname": "Pisoni",
            "contactid": "0fd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"110162114\"",
            "emailaddress1": "martin.margesin@epowertrac.com",
            "firstname": "Martin",
            "lastname": "Margesin",
            "contactid": "21d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"166876944\"",
            "emailaddress1": "elena.pasquali@ecosteer.com",
            "firstname": "Elena",
            "lastname": "Pasquali",
            "contactid": "23d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152470625\"",
            "emailaddress1": "giada.zanatta@ecosteer.com",
            "firstname": "Giada",
            "lastname": "Zanatta",
            "contactid": "25d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152470672\"",
            "emailaddress1": "dangraz@ecosteer.com",
            "firstname": "Daniel ",
            "lastname": "Grazioli",
            "contactid": "27d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152506095\"",
            "emailaddress1": "maicol@functionalgums.com",
            "firstname": "Maicol",
            "lastname": "Verzotto",
            "contactid": "33d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"113821588\"",
            "emailaddress1": "paolo@goodify.com",
            "firstname": "Paolo",
            "lastname": "Plebani",
            "contactid": "3bd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152473912\"",
            "emailaddress1": "tobias@gipsyway.it",
            "firstname": "Tobias",
            "lastname": "Marmsoler",
            "contactid": "3fd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"166541816\"",
            "emailaddress1": "d.basso@hbigroup.it",
            "firstname": "Daniele",
            "lastname": "Basso",
            "contactid": "41d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152471355\"",
            "emailaddress1": "michael.atzwanger@rolmail.net",
            "firstname": "Michael",
            "lastname": "Atzwanger",
            "contactid": "43d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152471381\"",
            "emailaddress1": "anna.trette@gmail.com",
            "firstname": "Anna",
            "lastname": "Trettenero",
            "contactid": "45d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152471479\"",
            "emailaddress1": "ceciaccoroni@gmail.com",
            "firstname": "Cecilia",
            "lastname": "Accoroni",
            "contactid": "47d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152472871\"",
            "emailaddress1": "morini@naturalsalus.it",
            "firstname": "Angelo",
            "lastname": "Morini",
            "contactid": "57d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"129642726\"",
            "emailaddress1": "diego.calvanese@ontopic.biz",
            "firstname": "Diego",
            "lastname": "Calvanese",
            "contactid": "59d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152474023\"",
            "emailaddress1": "benjamin.cogrel@bcgl.fr",
            "firstname": "Benjamin",
            "lastname": "Cogrel",
            "contactid": "5dd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152474884\"",
            "emailaddress1": "roman.morandell@pgum.eu",
            "firstname": "Roman",
            "lastname": "Morandell",
            "contactid": "67d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"190673821\"",
            "emailaddress1": "u.saccardo@bs89.com",
            "firstname": "Umberto",
            "lastname": "Saccardo",
            "contactid": "7fd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152475235\"",
            "emailaddress1": "luciano.delmastro@truckscreenia.com",
            "firstname": "Luciano",
            "lastname": "Delmastro",
            "contactid": "81d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"152475537\"",
            "emailaddress1": "nicola.maio@truckscreenia.com",
            "firstname": "Nicola",
            "lastname": "Maio",
            "contactid": "83d97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"164228808\"",
            "emailaddress1": "danilo@kibun.io",
            "firstname": "Danilo ",
            "lastname": "Fink",
            "contactid": "8bd97f07-9fb2-e911-a828-000d3a289705"
        },
        {
            "@odata.etag": "W/\"102577600\"",
            "emailaddress1": "h.hofer@noi.bz.it",
            "firstname": "Hubert",
            "lastname": "Hofer",
            "contactid": "e9b3b4ab-f6ce-e911-a82b-000d3a289fcd"
        },
        {
            "@odata.etag": "W/\"187127634\"",
            "emailaddress1": "astrid.weiss@sbb.it",
            "firstname": "Astrid",
            "lastname": "Weiss",
            "contactid": "fbb3b4ab-f6ce-e911-a82b-000d3a289fcd"
        },
        {
            "@odata.etag": "W/\"169962580\"",
            "emailaddress1": "laura.scafidi@eurac.edu",
            "firstname": "Laura",
            "lastname": "Scafidi",
            "contactid": "05b4b4ab-f6ce-e911-a82b-000d3a289fcd"
        },
        {
            "@odata.etag": "W/\"169964709\"",
            "emailaddress1": "ilaria.pagano@eurac.edu",
            "firstname": "Ilaria",
            "lastname": "Pagano",
            "contactid": "09b4b4ab-f6ce-e911-a82b-000d3a289fcd"
        }
    ]
}
toburger commented 2 years ago

Turns out I was lucky picking 181640000. It is indeed the ID for the "0. NOI-Community" choice value.

By providing the Prefer header with the value odata.include-annotations="OData.Community.Display.V1.FormattedValue" the API returns the "real" values of the choices (documented here).


The request

curl --request GET \
  --url 'https://noi.crm4.dynamics.com/api/data/v9.2/contacts?%24filter=Microsoft.Dynamics.CRM.ContainValues(PropertyName%3D%40p1%2CPropertyValues%3D%40p2)&%40p1='\''noi_contactcat_placepresscommunity'\''&%40p2=%5B'\''181640000'\''%5D&%24top=10&%24select=emailaddress1%2Cfirstname%2Clastname%2Cnoi_contactcat_placepresscommunity' \
  --header 'Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ik1yNS1BVWliZkJpaTdOZDFqQmViYXhib1hXMCIsImtpZCI6Ik1yNS1BVWliZkJpaTdOZDFqQmViYXhib1hXMCJ9.eyJhdWQiOiJodHRwczovL25vaS5jcm00LmR5bmFtaWNzLmNvbSIsImlzcyI6Imh0dHBzOi8vc3RzLndpbmRvd3MubmV0L2I2YWNmNTQ3LWMzNTItNDcwOC1hNzI1LWVjMGU2NjJjNWQxMS8iLCJpYXQiOjE2NDU3NzU3MzMsIm5iZiI6MTY0NTc3NTczMywiZXhwIjoxNjQ1Nzc5NjMzLCJhaW8iOiJFMlpnWURobVBVWEJKTmlIdGUyMnpKMklwMldsQUE9PSIsImFwcGlkIjoiNTM3ODZkNTktNGMzOS00NDZjLWI2MWUtMTNhNDZmZjY4ZDliIiwiYXBwaWRhY3IiOiIxIiwiaWRwIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvYjZhY2Y1NDctYzM1Mi00NzA4LWE3MjUtZWMwZTY2MmM1ZDExLyIsIm9pZCI6IjUxN2YwNGM4LTQ4NTItNGFmNC1iNTVjLWE5NDlhNGFlNjg0YyIsInJoIjoiMC5BVEFBUl9Xc3RsTERDRWVuSmV3T1ppeGRFUWNBQUFBQUFBQUF3QUFBQUFBQUFBQXdBQUEuIiwic3ViIjoiNTE3ZjA0YzgtNDg1Mi00YWY0LWI1NWMtYTk0OWE0YWU2ODRjIiwidGlkIjoiYjZhY2Y1NDctYzM1Mi00NzA4LWE3MjUtZWMwZTY2MmM1ZDExIiwidXRpIjoia24xaHJBZF9sMENxRGxyeGpfQURBQSIsInZlciI6IjEuMCJ9.f21d55Y8UpHQ77GwEsAG4Jv1ofUqnzUV5NSJjz2p-bnND7ytF2AlW0o7NU1DmkDPsIeWxJyu3ic3oetyCaTyTNFabpHApETsQqhoTCeNq8gDuWMPizVqiPG0zFodTH5_Njp4TIm5kIw9rLvf5QUydIqvdGx3F9yBNor2aCwm4LV92bEel37SZg0uhaa00EH5Zo-UjlXGwkR2dvUIyq9NM-tHXUDaVJ7hyr5y-hWoWWpEGAJ4vHI-9GCA2eUNfeJo42zg99sTLJOOeJ7UBebgT1mlVqAO6X-ngcuOOPPsnCY3W5U-eOyplFIMAJERQv_qzuWmjwxIUXGb4xF9opGE3Q' \
  --header 'Prefer: odata.include-annotations="OData.Community.Display.V1.FormattedValue"' \
  --cookie 'ARRAffinity=d92cd3895b41841ba1163bf4d56a8fc648b9a7157e761dc5d014f5ac9c0210f8; ReqClientId=56f5ef51-4fc6-420c-bce8-f599f412e754; orgId=e74b8429-b1f3-443c-8c30-9504c54cb762'

returns the following data

{
    "@odata.context": "https://noi.crm4.dynamics.com/api/data/v9.2/$metadata#contacts(emailaddress1,firstname,lastname,noi_contactcat_placepresscommunity)",
    "value": [
        {
            "@odata.etag": "W/\"152523145\"",
            "emailaddress1": "carlo.nainer@fraunhofer.it",
            "firstname": "Carlo",
            "lastname": "Nainer",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Research Institutions & University",
            "noi_contactcat_placepresscommunity": "181640000,181640003",
            "contactid": "8d8127c4-3162-eb11-a812-000d3a207473"
        },
        {
            "@odata.etag": "W/\"152523192\"",
            "emailaddress1": "luca.dallasta@fraunhofer.it",
            "firstname": "Luca",
            "lastname": "Dall'Asta",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Research Institutions & University",
            "noi_contactcat_placepresscommunity": "181640000,181640003",
            "contactid": "f6a788b0-4362-eb11-a812-000d3a207473"
        },
        {
            "@odata.etag": "W/\"152523184\"",
            "emailaddress1": "giada.malacarne@fraunhofer.it",
            "firstname": "Giada",
            "lastname": "Malacarne",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Research Institutions & University",
            "noi_contactcat_placepresscommunity": "181640000,181640003",
            "contactid": "39e10954-e25f-eb11-a812-000d3a207e17"
        },
        {
            "@odata.etag": "W/\"110484394\"",
            "emailaddress1": "s.canali@sheractive.com",
            "firstname": "Sara",
            "lastname": "Canali",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Start-ups",
            "noi_contactcat_placepresscommunity": "181640000,181640001",
            "contactid": "19015da2-40f4-eb11-94ef-000d3a226b93"
        },
        {
            "@odata.etag": "W/\"99385564\"",
            "emailaddress1": "f.ausserer@noi.bz.it",
            "firstname": "Francesca",
            "lastname": "Ausserer Wieser",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Research Institutions & University",
            "noi_contactcat_placepresscommunity": "181640000,181640003",
            "contactid": "30d43cfa-ebf5-eb11-94ef-000d3a226be2"
        },
        {
            "@odata.etag": "W/\"167035801\"",
            "emailaddress1": "c.cont@noi.bz.it",
            "firstname": "Christian",
            "lastname": "Cont",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Research Institutions & University",
            "noi_contactcat_placepresscommunity": "181640000,181640003",
            "contactid": "9db5762b-f0f5-eb11-94ef-000d3a226be2"
        },
        {
            "@odata.etag": "W/\"129641265\"",
            "emailaddress1": "diego.calvanese@ontopic.ai",
            "firstname": "Diego",
            "lastname": "Calvanese",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community",
            "noi_contactcat_placepresscommunity": "181640000",
            "contactid": "1876fd9c-93c7-eb11-bacc-000d3a26e1eb"
        },
        {
            "@odata.etag": "W/\"199936438\"",
            "emailaddress1": "milan.fanck@r3gis.com",
            "firstname": "Milan",
            "lastname": "Fanck",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Companies",
            "noi_contactcat_placepresscommunity": "181640000,181640002",
            "contactid": "1f0f4053-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"199936539\"",
            "emailaddress1": "valentina.polo@r3gis.com",
            "firstname": "Valentina",
            "lastname": "Polo",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Companies",
            "noi_contactcat_placepresscommunity": "181640000,181640002",
            "contactid": "d1292d6b-0c90-ec11-b400-000d3a27646d"
        },
        {
            "@odata.etag": "W/\"199936653\"",
            "emailaddress1": "gerhard.sulzberger@r3gis.com",
            "firstname": "Gerhard",
            "lastname": "Sulzberger",
            "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community; 1. Companies",
            "noi_contactcat_placepresscommunity": "181640000,181640002",
            "contactid": "767a1583-0c90-ec11-b400-000d3a27646d"
        }
    ]
}
sseppi commented 2 years ago

@toburger seems you got it! Does works the same for the Accounts?

Do we already have an Open data Hub that exposes this results?

toburger commented 2 years ago

Yes, no problem. But it looks like on the accounts the noi_contactcat_placepresscommunity field is missing.

Here the result an accounts query with 3 results:

{
    "@odata.context": "https://noi.crm4.dynamics.com/api/data/v9.2/$metadata#accounts",
    "@Microsoft.Dynamics.CRM.totalrecordcount": -1,
    "@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
    "value": [
        {
            "@odata.etag": "W/\"62306522\"",
            "customertypecode@OData.Community.Display.V1.FormattedValue": "Companies",
            "customertypecode": 1,
            "address2_addresstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_addresstypecode": 1,
            "merged@OData.Community.Display.V1.FormattedValue": "No",
            "merged": false,
            "statecode@OData.Community.Display.V1.FormattedValue": "Active",
            "statecode": 0,
            "exchangerate@OData.Community.Display.V1.FormattedValue": "1,0000000000",
            "exchangerate": 1.0000000000,
            "noi_nameit": "Bartenbach Lichtlabor",
            "name": "Bartenbach Lichtlabor",
            "modifiedon@OData.Community.Display.V1.FormattedValue": "25/01/2021 11:23",
            "modifiedon": "2021-01-25T11:23:01Z",
            "_owninguser_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_owninguser_value": "4f62e3cb-a986-e911-a819-000d3a289fcd",
            "address1_composite": "Rinner Straße 14\r\n6071 Aldrans Tirol\r\nAustria",
            "donotpostalmail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotpostalmail": false,
            "accountratingcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountratingcode": 1,
            "donotphone@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotphone": false,
            "preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue": "Any",
            "preferredcontactmethodcode": 1,
            "_ownerid_value@OData.Community.Display.V1.FormattedValue": "Pascal Vullo",
            "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid",
            "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_ownerid_value": "4f62e3cb-a986-e911-a819-000d3a289fcd",
            "openrevenue_date@OData.Community.Display.V1.FormattedValue": "11/03/2022 11:42",
            "openrevenue_date": "2022-03-11T11:42:17Z",
            "msevtmgt_rentalcarprovider@OData.Community.Display.V1.FormattedValue": "No",
            "msevtmgt_rentalcarprovider": 100000001,
            "businesstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "businesstypecode": 1,
            "donotemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotemail": false,
            "address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_shippingmethodcode": 1,
            "noi_vatnumber": "ATU36809600",
            "marketingonly@OData.Community.Display.V1.FormattedValue": "No",
            "marketingonly": false,
            "address1_addressid": "1f13d3ec-486b-4a36-b822-3f29f3d9f2f3",
            "address2_freighttermscode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_freighttermscode": 1,
            "statuscode@OData.Community.Display.V1.FormattedValue": "Active",
            "statuscode": 1,
            "createdon@OData.Community.Display.V1.FormattedValue": "25/01/2021 11:23",
            "createdon": "2021-01-25T11:23:01Z",
            "address1_stateorprovince": "Tirol",
            "donotbulkemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotbulkemail": false,
            "donotfax@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotfax": false,
            "donotbulkpostalmail@OData.Community.Display.V1.FormattedValue": "No",
            "donotbulkpostalmail": false,
            "address1_country": "Austria",
            "versionnumber@OData.Community.Display.V1.FormattedValue": "62.306.522",
            "versionnumber": 62306522,
            "address1_line1": "Rinner Straße 14",
            "creditonhold@OData.Community.Display.V1.FormattedValue": "No",
            "creditonhold": false,
            "donotsendmm@OData.Community.Display.V1.FormattedValue": "Send",
            "donotsendmm": false,
            "_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue": "euro",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "transactioncurrencyid",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "transactioncurrency",
            "_transactioncurrencyid_value": "e9906771-0380-e911-a97c-000d3a45ddd6",
            "accountid": "87e4aea9-ff5e-eb11-a812-000d3a207473",
            "new_isitastartup@OData.Community.Display.V1.FormattedValue": "No",
            "new_isitastartup": false,
            "msevtmgt_hotelgroup@OData.Community.Display.V1.FormattedValue": "No",
            "msevtmgt_hotelgroup": 100000001,
            "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "Pascal Vullo",
            "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_modifiedby_value": "4f62e3cb-a986-e911-a819-000d3a289fcd",
            "followemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "followemail": true,
            "shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "shippingmethodcode": 1,
            "_createdby_value@OData.Community.Display.V1.FormattedValue": "Pascal Vullo",
            "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_createdby_value": "4f62e3cb-a986-e911-a819-000d3a289fcd",
            "address1_city": "Aldrans",
            "territorycode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "territorycode": 1,
            "ownershipcode@OData.Community.Display.V1.FormattedValue": "Private",
            "ownershipcode": 2,
            "noi_noiactor@OData.Community.Display.V1.FormattedValue": "No",
            "noi_noiactor": false,
            "participatesinworkflow@OData.Community.Display.V1.FormattedValue": "No",
            "participatesinworkflow": false,
            "accountclassificationcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountclassificationcode": 1,
            "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "Tech Transfer Green",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
            "_owningbusinessunit_value": "efb32a7f-6b8c-e911-a81b-000d3a43d098",
            "address2_addressid": "2b18d12a-eece-44f9-9b97-438c81b13668",
            "address1_postalcode": "6071",
            "opendeals_date@OData.Community.Display.V1.FormattedValue": "11/03/2022 11:42",
            "opendeals_date": "2022-03-11T11:42:17Z",
            "telephone3": null,
            "address1_shippingmethodcode": null,
            "sharesoutstanding": null,
            "_defaultpricelevelid_value": null,
            "_preferredequipmentid_value": null,
            "address1_freighttermscode": null,
            "noi_associatedmembers": null,
            "address1_upszone": null,
            "crb14_accountcat_placepresscommunity": null,
            "websiteurl": null,
            "_slainvokedid_value": null,
            "address2_city": null,
            "address1_postofficebox": null,
            "importsequencenumber": null,
            "preferredappointmentdaycode": null,
            "utcconversiontimezonecode": null,
            "overriddencreatedon": null,
            "aging90": null,
            "stageid": null,
            "address1_utcoffset": null,
            "address1_latitude": null,
            "adx_createdbyipaddress": null,
            "_masterid_value": null,
            "lastonholdtime": null,
            "address2_fax": null,
            "accountnumber": null,
            "new_accountcatlabsperformance": null,
            "address2_line1": null,
            "address1_telephone3": null,
            "address1_telephone2": null,
            "address1_telephone1": null,
            "address2_postofficebox": null,
            "emailaddress1": null,
            "_primarycontactid_value": null,
            "emailaddress2": null,
            "ftpsiteurl": null,
            "processid": null,
            "address2_latitude": null,
            "emailaddress3": null,
            "address2_composite": null,
            "traversedpath": null,
            "new_accountcat_incubator": null,
            "address2_line2": null,
            "aging30_base": null,
            "numberofemployees": null,
            "address1_addresstypecode": null,
            "teamsfollowed": null,
            "address2_stateorprovince": null,
            "address2_postalcode": null,
            "_msa_managingpartnerid_value": null,
            "openrevenue_state": null,
            "entityimage_url": null,
            "aging60": null,
            "new_accountcat2_techtransferfood": null,
            "timezoneruleversionnumber": null,
            "address2_telephone3": null,
            "address2_telephone2": null,
            "address2_telephone1": null,
            "address2_upszone": null,
            "_owningteam_value": null,
            "primarysatoriid": null,
            "address2_line3": null,
            "timespentbymeonemailandmeetings": null,
            "opendeals_state": null,
            "address2_longitude": null,
            "_modifiedonbehalfby_value": null,
            "revenue_base": null,
            "creditlimit": null,
            "address1_line2": null,
            "paymenttermscode": null,
            "noi_industrytypecode": null,
            "new_accountcat_innovationmanagement": null,
            "address1_county": null,
            "_territoryid_value": null,
            "marketcap": null,
            "_preferredsystemuserid_value": null,
            "preferredappointmenttimecode": null,
            "address1_fax": null,
            "_createdonbehalfby_value": null,
            "address2_name": null,
            "creditlimit_base": null,
            "marketcap_base": null,
            "new_accountcat_techtransferaaa": null,
            "address2_utcoffset": null,
            "_modifiedbyexternalparty_value": null,
            "adx_modifiedbyusername": null,
            "_originatingleadid_value": null,
            "opendeals": null,
            "sic": null,
            "_preferredserviceid_value": null,
            "_slaid_value": null,
            "fax": null,
            "address2_county": null,
            "aging30": null,
            "address1_line3": null,
            "new_accountcat_eufunding": null,
            "openrevenue": null,
            "noi_taxnumber": null,
            "industrycode": null,
            "new_accountcat_sales": null,
            "new_accountcat_facilitymanagement": null,
            "customersizecode": null,
            "new_accountcat_techtransferdigital": null,
            "_createdbyexternalparty_value": null,
            "onholdtime": null,
            "msdyncrm_insights_placeholder": null,
            "entityimage_timestamp": null,
            "new_recipientcode": null,
            "entityimageid": null,
            "_parentaccountid_value": null,
            "yominame": null,
            "lastusedincampaign": null,
            "accountcategorycode": null,
            "openrevenue_base": null,
            "primarytwitterid": null,
            "msdyn_gdproptout": null,
            "adx_createdbyusername": null,
            "telephone2": null,
            "stockexchange": null,
            "revenue": null,
            "description": null,
            "_noi_industryid_value": null,
            "aging90_base": null,
            "new_accountcat_techtransfergreen": null,
            "tickersymbol": null,
            "new_accountcat_brandplace": null,
            "address1_name": null,
            "adx_modifiedbyipaddress": null,
            "telephone1": null,
            "address1_primarycontactname": null,
            "address1_longitude": null,
            "address2_primarycontactname": null,
            "entityimage": null,
            "aging60_base": null,
            "address2_country": null,
            "new_accountcat_techtransferfood": null
        },
        {
            "@odata.etag": "W/\"152646102\"",
            "customertypecode@OData.Community.Display.V1.FormattedValue": "Companies",
            "customertypecode": 1,
            "address2_addresstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_addresstypecode": 1,
            "merged@OData.Community.Display.V1.FormattedValue": "No",
            "merged": false,
            "statecode@OData.Community.Display.V1.FormattedValue": "Active",
            "statecode": 0,
            "exchangerate@OData.Community.Display.V1.FormattedValue": "1,0000000000",
            "exchangerate": 1.0000000000,
            "noi_nameit": "GMAR",
            "name": "GMAR",
            "modifiedon@OData.Community.Display.V1.FormattedValue": "24/11/2021 16:14",
            "modifiedon": "2021-11-24T16:14:07Z",
            "_owninguser_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_owninguser_value": "2d51e5ee-fa81-e911-a817-000d3a43d4be",
            "address1_composite": "Wien\r\nAustria",
            "donotpostalmail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotpostalmail": false,
            "accountratingcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountratingcode": 1,
            "donotphone@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotphone": false,
            "preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue": "Any",
            "preferredcontactmethodcode": 1,
            "_ownerid_value@OData.Community.Display.V1.FormattedValue": "Andreas Winkler",
            "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid",
            "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_ownerid_value": "2d51e5ee-fa81-e911-a817-000d3a43d4be",
            "openrevenue_date@OData.Community.Display.V1.FormattedValue": "11/03/2022 11:42",
            "openrevenue_date": "2022-03-11T11:42:17Z",
            "msevtmgt_rentalcarprovider@OData.Community.Display.V1.FormattedValue": "No",
            "msevtmgt_rentalcarprovider": 100000001,
            "businesstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "businesstypecode": 1,
            "donotemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotemail": false,
            "address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_shippingmethodcode": 1,
            "noi_vatnumber": "0123456789",
            "marketingonly@OData.Community.Display.V1.FormattedValue": "No",
            "marketingonly": false,
            "address1_addressid": "0ba4ffa6-c334-4506-ac51-4def813c2261",
            "address2_freighttermscode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_freighttermscode": 1,
            "statuscode@OData.Community.Display.V1.FormattedValue": "Active",
            "statuscode": 1,
            "createdon@OData.Community.Display.V1.FormattedValue": "26/01/2021 08:41",
            "createdon": "2021-01-26T08:41:17Z",
            "address1_stateorprovince": null,
            "donotbulkemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotbulkemail": false,
            "donotfax@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotfax": false,
            "donotbulkpostalmail@OData.Community.Display.V1.FormattedValue": "No",
            "donotbulkpostalmail": false,
            "address1_country": "Austria",
            "versionnumber@OData.Community.Display.V1.FormattedValue": "152.646.102",
            "versionnumber": 152646102,
            "address1_line1": null,
            "creditonhold@OData.Community.Display.V1.FormattedValue": "No",
            "creditonhold": false,
            "donotsendmm@OData.Community.Display.V1.FormattedValue": "Send",
            "donotsendmm": false,
            "_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue": "euro",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "transactioncurrencyid",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "transactioncurrency",
            "_transactioncurrencyid_value": "e9906771-0380-e911-a97c-000d3a45ddd6",
            "accountid": "af2acb40-b25f-eb11-a812-000d3a207473",
            "new_isitastartup@OData.Community.Display.V1.FormattedValue": "No",
            "new_isitastartup": false,
            "msevtmgt_hotelgroup@OData.Community.Display.V1.FormattedValue": "No",
            "msevtmgt_hotelgroup": 100000001,
            "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "Johannes Brunner",
            "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_modifiedby_value": "a273ece2-fa81-e911-a817-000d3a43d4be",
            "followemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "followemail": true,
            "shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "shippingmethodcode": 1,
            "_createdby_value@OData.Community.Display.V1.FormattedValue": "Andreas Winkler",
            "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_createdby_value": "2d51e5ee-fa81-e911-a817-000d3a43d4be",
            "address1_city": "Wien",
            "territorycode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "territorycode": 1,
            "ownershipcode@OData.Community.Display.V1.FormattedValue": "Private",
            "ownershipcode": 2,
            "noi_noiactor@OData.Community.Display.V1.FormattedValue": "No",
            "noi_noiactor": false,
            "participatesinworkflow@OData.Community.Display.V1.FormattedValue": "No",
            "participatesinworkflow": false,
            "accountclassificationcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountclassificationcode": 1,
            "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "Customer Management",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
            "_owningbusinessunit_value": "906f29d5-5085-e911-a819-000d3a43d6e1",
            "address2_addressid": "7d5a1532-637e-4ce2-9071-eeff13cd9840",
            "address1_postalcode": null,
            "opendeals_date@OData.Community.Display.V1.FormattedValue": "11/03/2022 11:42",
            "opendeals_date": "2022-03-11T11:42:17Z",
            "telephone3": null,
            "address1_shippingmethodcode": null,
            "sharesoutstanding": null,
            "_defaultpricelevelid_value": null,
            "_preferredequipmentid_value": null,
            "address1_freighttermscode": null,
            "noi_associatedmembers": null,
            "address1_upszone": null,
            "crb14_accountcat_placepresscommunity": null,
            "websiteurl": null,
            "_slainvokedid_value": null,
            "address2_city": null,
            "address1_postofficebox": null,
            "importsequencenumber": null,
            "preferredappointmentdaycode": null,
            "utcconversiontimezonecode": null,
            "overriddencreatedon": null,
            "aging90": null,
            "stageid": null,
            "address1_utcoffset": null,
            "address1_latitude": null,
            "adx_createdbyipaddress": null,
            "_masterid_value": null,
            "lastonholdtime": null,
            "address2_fax": null,
            "accountnumber": null,
            "new_accountcatlabsperformance": null,
            "address2_line1": null,
            "address1_telephone3": null,
            "address1_telephone2": null,
            "address1_telephone1": null,
            "address2_postofficebox": null,
            "emailaddress1": "a.numrich@gmar.at",
            "_primarycontactid_value@OData.Community.Display.V1.FormattedValue": "NUMRICH Alexander",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "primarycontactid",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact",
            "_primarycontactid_value": "ae2acb40-b25f-eb11-a812-000d3a207473",
            "emailaddress2": null,
            "ftpsiteurl": null,
            "processid": null,
            "address2_latitude": null,
            "emailaddress3": null,
            "address2_composite": null,
            "traversedpath": null,
            "new_accountcat_incubator": null,
            "address2_line2": null,
            "aging30_base": null,
            "numberofemployees": null,
            "address1_addresstypecode": null,
            "teamsfollowed": null,
            "address2_stateorprovince": null,
            "address2_postalcode": null,
            "_msa_managingpartnerid_value": null,
            "openrevenue_state": null,
            "entityimage_url": null,
            "aging60": null,
            "new_accountcat2_techtransferfood": null,
            "timezoneruleversionnumber": null,
            "address2_telephone3": null,
            "address2_telephone2": null,
            "address2_telephone1": null,
            "address2_upszone": null,
            "_owningteam_value": null,
            "primarysatoriid": null,
            "address2_line3": null,
            "timespentbymeonemailandmeetings": null,
            "opendeals_state": null,
            "address2_longitude": null,
            "_modifiedonbehalfby_value": null,
            "revenue_base": null,
            "creditlimit": null,
            "address1_line2": null,
            "paymenttermscode": null,
            "noi_industrytypecode": null,
            "new_accountcat_innovationmanagement": null,
            "address1_county": null,
            "_territoryid_value": null,
            "marketcap": null,
            "_preferredsystemuserid_value": null,
            "preferredappointmenttimecode": null,
            "address1_fax": null,
            "_createdonbehalfby_value": null,
            "address2_name": null,
            "creditlimit_base": null,
            "marketcap_base": null,
            "new_accountcat_techtransferaaa": null,
            "address2_utcoffset": null,
            "_modifiedbyexternalparty_value": null,
            "adx_modifiedbyusername": null,
            "_originatingleadid_value@OData.Community.Display.V1.FormattedValue": "NUMRICH Alexander",
            "_originatingleadid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "originatingleadid",
            "_originatingleadid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "lead",
            "_originatingleadid_value": "267617d8-a8f1-4a67-b3e0-dcbbcbff6282",
            "opendeals": null,
            "sic": null,
            "_preferredserviceid_value": null,
            "_slaid_value": null,
            "fax": null,
            "address2_county": null,
            "aging30": null,
            "address1_line3": null,
            "new_accountcat_eufunding": null,
            "openrevenue": null,
            "noi_taxnumber": null,
            "industrycode": null,
            "new_accountcat_sales": null,
            "new_accountcat_facilitymanagement": null,
            "customersizecode": null,
            "new_accountcat_techtransferdigital": null,
            "_createdbyexternalparty_value": null,
            "onholdtime": null,
            "msdyncrm_insights_placeholder": null,
            "entityimage_timestamp": null,
            "new_recipientcode": null,
            "entityimageid": null,
            "_parentaccountid_value": null,
            "yominame": null,
            "lastusedincampaign": null,
            "accountcategorycode": null,
            "openrevenue_base": null,
            "primarytwitterid": null,
            "msdyn_gdproptout": null,
            "adx_createdbyusername": null,
            "telephone2": null,
            "stockexchange": null,
            "revenue": null,
            "description": null,
            "_noi_industryid_value": null,
            "aging90_base": null,
            "new_accountcat_techtransfergreen": null,
            "tickersymbol": null,
            "new_accountcat_brandplace": null,
            "address1_name": null,
            "adx_modifiedbyipaddress": null,
            "telephone1": null,
            "address1_primarycontactname": null,
            "address1_longitude": null,
            "address2_primarycontactname": null,
            "entityimage": null,
            "aging60_base": null,
            "address2_country": null,
            "new_accountcat_techtransferfood": null
        },
        {
            "@odata.etag": "W/\"70432610\"",
            "customertypecode@OData.Community.Display.V1.FormattedValue": "Companies",
            "customertypecode": 1,
            "address2_addresstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_addresstypecode": 1,
            "merged@OData.Community.Display.V1.FormattedValue": "No",
            "merged": false,
            "statecode@OData.Community.Display.V1.FormattedValue": "Active",
            "statecode": 0,
            "exchangerate@OData.Community.Display.V1.FormattedValue": "1,0000000000",
            "exchangerate": 1.0000000000,
            "noi_nameit": "Wico GmbH",
            "name": "Wico GmbH",
            "modifiedon@OData.Community.Display.V1.FormattedValue": "15/03/2021 14:20",
            "modifiedon": "2021-03-15T14:20:16Z",
            "_owninguser_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_owninguser_value": "9270ebf4-fa81-e911-a817-000d3a43d4be",
            "address1_composite": "Mendelgasse 19A\r\n39100 Bozen (BZ)\r\nItaly",
            "donotpostalmail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotpostalmail": false,
            "accountratingcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountratingcode": 1,
            "donotphone@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotphone": false,
            "preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue": "Any",
            "preferredcontactmethodcode": 1,
            "_ownerid_value@OData.Community.Display.V1.FormattedValue": "Walter Weissensteiner",
            "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid",
            "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_ownerid_value": "9270ebf4-fa81-e911-a817-000d3a43d4be",
            "openrevenue_date@OData.Community.Display.V1.FormattedValue": "11/03/2022 11:42",
            "openrevenue_date": "2022-03-11T11:42:17Z",
            "msevtmgt_rentalcarprovider@OData.Community.Display.V1.FormattedValue": "No",
            "msevtmgt_rentalcarprovider": 100000001,
            "businesstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "businesstypecode": 1,
            "donotemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotemail": false,
            "address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_shippingmethodcode": 1,
            "noi_vatnumber": "00755530219",
            "marketingonly@OData.Community.Display.V1.FormattedValue": "No",
            "marketingonly": false,
            "address1_addressid": "e08019b2-e199-4f66-9c78-8a2a3c07c8e6",
            "address2_freighttermscode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_freighttermscode": 1,
            "statuscode@OData.Community.Display.V1.FormattedValue": "Active",
            "statuscode": 1,
            "createdon@OData.Community.Display.V1.FormattedValue": "25/01/2021 15:01",
            "createdon": "2021-01-25T15:01:57Z",
            "address1_stateorprovince": "BZ",
            "donotbulkemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotbulkemail": false,
            "donotfax@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotfax": false,
            "donotbulkpostalmail@OData.Community.Display.V1.FormattedValue": "No",
            "donotbulkpostalmail": false,
            "address1_country": "Italy",
            "versionnumber@OData.Community.Display.V1.FormattedValue": "70.432.610",
            "versionnumber": 70432610,
            "address1_line1": "Mendelgasse 19A",
            "creditonhold@OData.Community.Display.V1.FormattedValue": "No",
            "creditonhold": false,
            "donotsendmm@OData.Community.Display.V1.FormattedValue": "Send",
            "donotsendmm": false,
            "_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue": "euro",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "transactioncurrencyid",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "transactioncurrency",
            "_transactioncurrencyid_value": "e9906771-0380-e911-a97c-000d3a45ddd6",
            "accountid": "b27b7140-1e5f-eb11-a812-000d3a207e17",
            "new_isitastartup@OData.Community.Display.V1.FormattedValue": "No",
            "new_isitastartup": false,
            "msevtmgt_hotelgroup@OData.Community.Display.V1.FormattedValue": "No",
            "msevtmgt_hotelgroup": 100000001,
            "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "Diego Andreasi",
            "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_modifiedby_value": "919208fb-fa81-e911-a817-000d3a43d4be",
            "followemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "followemail": true,
            "shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "shippingmethodcode": 1,
            "_createdby_value@OData.Community.Display.V1.FormattedValue": "# D365AppUser",
            "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_createdby_value": "43a208d7-f1b8-e911-a825-000d3a43d70a",
            "address1_city": "Bozen",
            "territorycode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "territorycode": 1,
            "ownershipcode@OData.Community.Display.V1.FormattedValue": "Private",
            "ownershipcode": 2,
            "noi_noiactor@OData.Community.Display.V1.FormattedValue": "No",
            "noi_noiactor": false,
            "participatesinworkflow@OData.Community.Display.V1.FormattedValue": "No",
            "participatesinworkflow": false,
            "accountclassificationcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountclassificationcode": 1,
            "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "Labs & Performance",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
            "_owningbusinessunit_value": "da2884c4-5085-e911-a819-000d3a43d6e1",
            "address2_addressid": "66e7735e-50eb-4a4a-a345-40ff92c0d60e",
            "address1_postalcode": "39100",
            "opendeals_date@OData.Community.Display.V1.FormattedValue": "11/03/2022 11:42",
            "opendeals_date": "2022-03-11T11:42:17Z",
            "telephone3": null,
            "address1_shippingmethodcode": null,
            "sharesoutstanding": null,
            "_defaultpricelevelid_value": null,
            "_preferredequipmentid_value": null,
            "address1_freighttermscode": null,
            "noi_associatedmembers": null,
            "address1_upszone": null,
            "crb14_accountcat_placepresscommunity": null,
            "websiteurl": null,
            "_slainvokedid_value": null,
            "address2_city": null,
            "address1_postofficebox": null,
            "importsequencenumber": null,
            "preferredappointmentdaycode": null,
            "utcconversiontimezonecode": null,
            "overriddencreatedon": null,
            "aging90": null,
            "stageid": null,
            "address1_utcoffset": null,
            "address1_latitude": null,
            "adx_createdbyipaddress": null,
            "_masterid_value": null,
            "lastonholdtime": null,
            "address2_fax": null,
            "accountnumber": null,
            "new_accountcatlabsperformance@OData.Community.Display.V1.FormattedValue": "Utente Maker Space",
            "new_accountcatlabsperformance": "1",
            "address2_line1": null,
            "address1_telephone3": null,
            "address1_telephone2": null,
            "address1_telephone1": null,
            "address2_postofficebox": null,
            "emailaddress1": null,
            "_primarycontactid_value@OData.Community.Display.V1.FormattedValue": "Claudio Manfrini",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "primarycontactid",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact",
            "_primarycontactid_value": "ae3b2245-1e5f-eb11-a812-000d3a207473",
            "emailaddress2": null,
            "ftpsiteurl": null,
            "processid": null,
            "address2_latitude": null,
            "emailaddress3": null,
            "address2_composite": null,
            "traversedpath": null,
            "new_accountcat_incubator": null,
            "address2_line2": null,
            "aging30_base": null,
            "numberofemployees": null,
            "address1_addresstypecode": null,
            "teamsfollowed": null,
            "address2_stateorprovince": null,
            "address2_postalcode": null,
            "_msa_managingpartnerid_value": null,
            "openrevenue_state": null,
            "entityimage_url": null,
            "aging60": null,
            "new_accountcat2_techtransferfood": null,
            "timezoneruleversionnumber": null,
            "address2_telephone3": null,
            "address2_telephone2": null,
            "address2_telephone1": null,
            "address2_upszone": null,
            "_owningteam_value": null,
            "primarysatoriid": null,
            "address2_line3": null,
            "timespentbymeonemailandmeetings": null,
            "opendeals_state": null,
            "address2_longitude": null,
            "_modifiedonbehalfby_value": null,
            "revenue_base": null,
            "creditlimit": null,
            "address1_line2": null,
            "paymenttermscode": null,
            "noi_industrytypecode": null,
            "new_accountcat_innovationmanagement": null,
            "address1_county": null,
            "_territoryid_value": null,
            "marketcap": null,
            "_preferredsystemuserid_value": null,
            "preferredappointmenttimecode": null,
            "address1_fax": null,
            "_createdonbehalfby_value": null,
            "address2_name": null,
            "creditlimit_base": null,
            "marketcap_base": null,
            "new_accountcat_techtransferaaa": null,
            "address2_utcoffset": null,
            "_modifiedbyexternalparty_value": null,
            "adx_modifiedbyusername": null,
            "_originatingleadid_value": null,
            "opendeals": null,
            "sic": null,
            "_preferredserviceid_value": null,
            "_slaid_value": null,
            "fax": null,
            "address2_county": null,
            "aging30": null,
            "address1_line3": null,
            "new_accountcat_eufunding": null,
            "openrevenue": null,
            "noi_taxnumber": "00755530219",
            "industrycode": null,
            "new_accountcat_sales": null,
            "new_accountcat_facilitymanagement": null,
            "customersizecode": null,
            "new_accountcat_techtransferdigital": null,
            "_createdbyexternalparty_value": null,
            "onholdtime": null,
            "msdyncrm_insights_placeholder": null,
            "entityimage_timestamp": null,
            "new_recipientcode": "USAL8PV",
            "entityimageid": null,
            "_parentaccountid_value": null,
            "yominame": null,
            "lastusedincampaign": null,
            "accountcategorycode": null,
            "openrevenue_base": null,
            "primarytwitterid": null,
            "msdyn_gdproptout": null,
            "adx_createdbyusername": null,
            "telephone2": null,
            "stockexchange": null,
            "revenue": null,
            "description": null,
            "_noi_industryid_value": null,
            "aging90_base": null,
            "new_accountcat_techtransfergreen": null,
            "tickersymbol": null,
            "new_accountcat_brandplace": null,
            "address1_name": null,
            "adx_modifiedbyipaddress": null,
            "telephone1": null,
            "address1_primarycontactname": null,
            "address1_longitude": null,
            "address2_primarycontactname": null,
            "entityimage": null,
            "aging60_base": null,
            "address2_country": null,
            "new_accountcat_techtransferfood": null
        }
    ]
}
sseppi commented 2 years ago

@toburger it seems that for the accounts we got the wrong three accounts. In The test CRM have been tagged as NOI_Community the accounts you can see in the following screenshot.

Schermata da 2022-03-15 11-24-14

Can you please check, and let me know if you need help from the CRM support team.

sseppi commented 2 years ago

@toburger probably also on the Contacts we didn't get the right code. At the following image you can find the list of the actual NOI Community contact provided

Schermata da 2022-03-15 11-44-23 by the testing CRM

Can you please check, and let me know if you need help from the CRM support team.

toburger commented 2 years ago

For the accounts: I've made a query for "Loacker AG" and the following data gets returned:

{
    "@odata.context": "https://noi.crm4.dynamics.com/api/data/v9.2/$metadata#accounts",
    "@Microsoft.Dynamics.CRM.totalrecordcount": -1,
    "@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
    "value": [
        {
            "@odata.etag": "W/\"204174832\"",
            "customertypecode@OData.Community.Display.V1.FormattedValue": "Companies",
            "customertypecode": 1,
            "address2_addresstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_addresstypecode": 1,
            "merged@OData.Community.Display.V1.FormattedValue": "No",
            "merged": false,
            "statecode@OData.Community.Display.V1.FormattedValue": "Active",
            "statecode": 0,
            "emailaddress1": "info@loacker.com",
            "exchangerate@OData.Community.Display.V1.FormattedValue": "1,0000000000",
            "exchangerate": 1.0000000000,
            "noi_nameit": "Loacker Spa",
            "accountcategorycode@OData.Community.Display.V1.FormattedValue": "A",
            "accountcategorycode": 1,
            "name": "Loacker AG",
            "websiteurl": "http://www.loacker.com",
            "modifiedon@OData.Community.Display.V1.FormattedValue": "24/02/2022 14:53",
            "modifiedon": "2022-02-24T14:53:40Z",
            "_owninguser_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_owninguser_value": "13371635-371b-44e5-8498-c8bac80ad42b",
            "_primarycontactid_value@OData.Community.Display.V1.FormattedValue": "Andreas Loacker",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "primarycontactid",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact",
            "_primarycontactid_value": "f02cd75e-cdbf-eb11-bacc-000d3a464877",
            "importsequencenumber@OData.Community.Display.V1.FormattedValue": "4",
            "importsequencenumber": 4,
            "address1_composite": "Gastererweg 3\r\n39054 Unterinn-Ritten (BZ)\r\nItaly",
            "donotpostalmail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotpostalmail": false,
            "accountratingcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountratingcode": 1,
            "numberofemployees@OData.Community.Display.V1.FormattedValue": "982",
            "numberofemployees": 982,
            "marketingonly@OData.Community.Display.V1.FormattedValue": "No",
            "marketingonly": false,
            "revenue_base@OData.Community.Display.V1.FormattedValue": "312.000.000,00 €",
            "revenue_base": 312000000.0000,
            "preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue": "Any",
            "preferredcontactmethodcode": 1,
            "new_accountcat_innovationmanagement@OData.Community.Display.V1.FormattedValue": "1-Azienda; 2-Food Tech.; 0-Category: A",
            "new_accountcat_innovationmanagement": "100000000,100000007,100000010",
            "_ownerid_value@OData.Community.Display.V1.FormattedValue": "EOS Solutions",
            "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid",
            "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_ownerid_value": "13371635-371b-44e5-8498-c8bac80ad42b",
            "description": "Entrata al NOI Techpark a ottobre 2019",
            "customersizecode@OData.Community.Display.V1.FormattedValue": "Large Enterprise",
            "customersizecode": 100000004,
            "openrevenue_date@OData.Community.Display.V1.FormattedValue": "14/03/2022 09:42",
            "openrevenue_date": "2022-03-14T09:42:18Z",
            "_noi_industryid_value@OData.Community.Display.V1.FormattedValue": "10-Industrie alimentari",
            "_noi_industryid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "noi_industryid",
            "_noi_industryid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "noi_industry",
            "_noi_industryid_value": "3525b556-3a8c-e911-a828-000d3ab71eab",
            "businesstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "businesstypecode": 1,
            "donotemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotemail": false,
            "address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_shippingmethodcode": 1,
            "noi_vatnumber": "2666430216",
            "revenue@OData.Community.Display.V1.FormattedValue": "312.000.000,00 €",
            "revenue": 312000000.0000,
            "address2_freighttermscode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "address2_freighttermscode": 1,
            "statuscode@OData.Community.Display.V1.FormattedValue": "Active",
            "statuscode": 1,
            "createdon@OData.Community.Display.V1.FormattedValue": "10/07/2019 12:45",
            "createdon": "2019-07-10T12:45:43Z",
            "address1_stateorprovince": "BZ",
            "donotsendmm@OData.Community.Display.V1.FormattedValue": "Send",
            "donotsendmm": false,
            "donotfax@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotfax": false,
            "donotbulkpostalmail@OData.Community.Display.V1.FormattedValue": "No",
            "donotbulkpostalmail": false,
            "new_accountcatlabsperformance@OData.Community.Display.V1.FormattedValue": "0-Category: A",
            "new_accountcatlabsperformance": "100000001",
            "noi_industrytypecode@OData.Community.Display.V1.FormattedValue": "C-ATTIVITÀ MANIFATTURIERE",
            "noi_industrytypecode": 3,
            "address1_country": "Italy",
            "versionnumber@OData.Community.Display.V1.FormattedValue": "204.174.832",
            "versionnumber": 204174832,
            "address1_line1": "Gastererweg 3",
            "creditonhold@OData.Community.Display.V1.FormattedValue": "No",
            "creditonhold": false,
            "new_accountcat_techtransferdigital@OData.Community.Display.V1.FormattedValue": "0-Category: B+",
            "new_accountcat_techtransferdigital": "100000001",
            "telephone1": "+39 0471 344 000",
            "donotphone@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotphone": false,
            "_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue": "euro",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "transactioncurrencyid",
            "_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "transactioncurrency",
            "_transactioncurrencyid_value": "e9906771-0380-e911-a97c-000d3a45ddd6",
            "accountid": "bf00c31a-10a3-e911-a821-000d3a289705",
            "new_isitastartup@OData.Community.Display.V1.FormattedValue": "No",
            "new_isitastartup": false,
            "donotbulkemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "donotbulkemail": false,
            "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "Luca Miotto",
            "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_modifiedby_value": "e750e5ee-fa81-e911-a817-000d3a43d4be",
            "followemail@OData.Community.Display.V1.FormattedValue": "Allow",
            "followemail": true,
            "shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "shippingmethodcode": 1,
            "new_accountcat2_techtransferfood@OData.Community.Display.V1.FormattedValue": "0-Category: A",
            "new_accountcat2_techtransferfood": "100000000",
            "_createdby_value@OData.Community.Display.V1.FormattedValue": "EOS Solutions",
            "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
            "_createdby_value": "13371635-371b-44e5-8498-c8bac80ad42b",
            "new_accountcat_techtransfergreen@OData.Community.Display.V1.FormattedValue": "1-Azienda; 2-Altro; 0-Category: B-",
            "new_accountcat_techtransfergreen": "100000002,100000011,100000038",
            "address1_city": "Unterinn-Ritten",
            "territorycode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "territorycode": 1,
            "new_accountcat_techtransferfood@OData.Community.Display.V1.FormattedValue": "0-Category: A",
            "new_accountcat_techtransferfood": "100000000",
            "ownershipcode@OData.Community.Display.V1.FormattedValue": "Private",
            "ownershipcode": 2,
            "noi_noiactor@OData.Community.Display.V1.FormattedValue": "Yes",
            "noi_noiactor": true,
            "address1_addressid": "ff2f5a60-d520-469e-899c-dfff9ed138bd",
            "participatesinworkflow@OData.Community.Display.V1.FormattedValue": "No",
            "participatesinworkflow": false,
            "accountclassificationcode@OData.Community.Display.V1.FormattedValue": "Default Value",
            "accountclassificationcode": 1,
            "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "noi",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit",
            "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
            "_owningbusinessunit_value": "107fe7f1-f67f-e911-a97c-000d3a45ddd6",
            "address2_addressid": "c80d509d-a198-4be2-9822-bc40c928c130",
            "address1_postalcode": "39054",
            "opendeals_date@OData.Community.Display.V1.FormattedValue": "14/03/2022 09:42",
            "opendeals_date": "2022-03-14T09:42:18Z",
            "new_accountcat_eufunding": null,
            "lastusedincampaign": null,
            "address1_name": null,
            "address1_telephone2": null,
            "overriddencreatedon": null,
            "entityimageid": null,
            "new_accountcat_sales": null,
            "creditlimit": null,
            "entityimage_url": null,
            "timezoneruleversionnumber": null,
            "entityimage_timestamp": null,
            "telephone3": null,
            "address1_freighttermscode": null,
            "adx_modifiedbyusername": null,
            "onholdtime": null,
            "telephone2": null,
            "new_accountcat_techtransferaaa": null,
            "address2_telephone1": null,
            "address1_fax": null,
            "_createdonbehalfby_value": null,
            "address2_city": null,
            "_msa_managingpartnerid_value": null,
            "address2_latitude": null,
            "msdyn_gdproptout": null,
            "noi_associatedmembers": null,
            "entityimage": null,
            "address1_postofficebox": null,
            "marketcap": null,
            "aging90_base": null,
            "address2_postalcode": null,
            "address2_name": null,
            "primarysatoriid": null,
            "adx_modifiedbyipaddress": null,
            "_masterid_value": null,
            "adx_createdbyusername": null,
            "accountnumber": null,
            "aging30": null,
            "address2_county": null,
            "_originatingleadid_value": null,
            "emailaddress3": null,
            "_modifiedbyexternalparty_value": null,
            "address1_shippingmethodcode": null,
            "new_accountcat_facilitymanagement": null,
            "paymenttermscode": null,
            "new_recipientcode": null,
            "lastonholdtime": null,
            "sic": null,
            "address1_line2": null,
            "creditlimit_base": null,
            "opendeals_state": null,
            "_preferredsystemuserid_value": null,
            "_defaultpricelevelid_value": null,
            "address1_primarycontactname": null,
            "openrevenue_state": null,
            "openrevenue": null,
            "address1_latitude": null,
            "address1_county": null,
            "address2_postofficebox": null,
            "_preferredserviceid_value": null,
            "address1_upszone": null,
            "new_accountcat_brandplace": null,
            "utcconversiontimezonecode": null,
            "aging60": null,
            "address2_longitude": null,
            "aging30_base": null,
            "yominame": null,
            "address2_country": null,
            "crb14_accountcat_placepresscommunity": null,
            "openrevenue_base": null,
            "tickersymbol": null,
            "address2_upszone": null,
            "aging90": null,
            "address1_longitude": null,
            "msdyncrm_insights_placeholder": null,
            "noi_taxnumber": null,
            "address1_telephone1": null,
            "address2_line1": null,
            "_owningteam_value": null,
            "address2_telephone2": null,
            "address2_line2": null,
            "primarytwitterid": null,
            "timespentbymeonemailandmeetings": null,
            "msevtmgt_hotelgroup": null,
            "address2_composite": null,
            "_slaid_value": null,
            "ftpsiteurl": null,
            "stageid": null,
            "address2_primarycontactname": null,
            "_preferredequipmentid_value": null,
            "preferredappointmenttimecode": null,
            "processid": null,
            "address1_addresstypecode": null,
            "address1_utcoffset": null,
            "_parentaccountid_value": null,
            "_createdbyexternalparty_value": null,
            "address2_fax": null,
            "aging60_base": null,
            "_modifiedonbehalfby_value": null,
            "stockexchange": null,
            "preferredappointmentdaycode": null,
            "adx_createdbyipaddress": null,
            "address1_line3": null,
            "msevtmgt_rentalcarprovider": null,
            "fax": null,
            "address2_telephone3": null,
            "sharesoutstanding": null,
            "_slainvokedid_value": null,
            "_territoryid_value": null,
            "address2_line3": null,
            "traversedpath": null,
            "teamsfollowed": null,
            "address2_utcoffset": null,
            "opendeals": null,
            "address2_stateorprovince": null,
            "emailaddress2": null,
            "marketcap_base": null,
            "new_accountcat_incubator": null,
            "industrycode": null,
            "address1_telephone3": null
        }
    ]
}

There is the information of the contact person for the company here:

            "_primarycontactid_value@OData.Community.Display.V1.FormattedValue": "Andreas Loacker",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "primarycontactid",
            "_primarycontactid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact",
            "_primarycontactid_value": "f02cd75e-cdbf-eb11-bacc-000d3a464877",

I try to get the expanded primary contact id and then filter the contact by the noi_contactcat_placepresscommunity.

toburger commented 2 years ago

I was partially successfull:

The followin query produces the following response:

{
    "@odata.context": "https://noi.crm4.dynamics.com/api/data/v9.2/$metadata#accounts(name,primarycontactid,primarycontactid(emailaddress1,firstname,lastname,noi_contactcat_placepresscommunity))",
    "@Microsoft.Dynamics.CRM.totalrecordcount": -1,
    "@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
    "value": [
        {
            "@odata.etag": "W/\"61617658\"",
            "name": "Weico GmbH",
            "accountid": "55c10558-a551-ea11-a812-000d3a2bc66a",
            "primarycontactid": {
                "emailaddress1": "christof.weissteiner@weico.it",
                "firstname": "Christof",
                "lastname": "Weissteiner",
                "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community",
                "noi_contactcat_placepresscommunity": "181640000",
                "contactid": "aa33e96f-a551-ea11-a812-000d3a2bc66a"
            }
        },
        {
            "@odata.etag": "W/\"195991599\"",
            "name": "Torggler Chimica AG",
            "accountid": "acb14d2b-dbb1-e911-a823-000d3a3a6da8",
            "primarycontactid": {
                "emailaddress1": "stefano.rocchetti@torggler.com",
                "firstname": "Stefano",
                "lastname": "Rocchetti",
                "noi_contactcat_placepresscommunity@OData.Community.Display.V1.FormattedValue": "0. NOI-Community",
                "noi_contactcat_placepresscommunity": "181640000",
                "contactid": "582eacc4-d0b1-e911-a824-000d3a43d70a"
            }
        }
    ]
}

Now there is one problem though:

I cannot use the Microsoft.Dynamics.CRM.ContainValues query filter as I can't query sub fields with this special filter. What I am doing now is that I am comparing against a single value, but the noi_contactcat_placepresscommunity can contain multiple values. NOI has probably assigned multiple values and therefore the account doesn't get returned.


I can imagine the following solutions:

1) Find the correct syntax to query for a MultiSelectPicklistAttribute of a child property (primarycontactid/noi_contactcat_placepresscommunity). Maybe the CRM support team could help. 1) Define on the Microsoft Dynamics site a boolean field which contains the information if the contact/account is member of the noi community. This should be possible with a computed field? I am no Dynamics expert but it should be possible to define a field which in turn reads the information from the existing noi_contactcat_placepresscommunity field in Dynamics. 1) Copy the noi_contactcat_placepresscommunity from the contacts to the corresponding account. 1) First read all the contacts which are member of the noi community, remember their ids and make a second query on the accounts endpoint with the list of the contactids. This method does not work, as the OData endpoint of Dynamics does not implement the in operator! But the in part could be replaced by a bunch of or statements.

toburger commented 2 years ago

To continue with solution 4) the following query works:

https://noi.crm4.dynamics.com/api/data/v9.2/accounts?%24top=100&%24select=name,primarycontactid&%24filter=primarycontactid%2Fcontactid%20eq%20'582eacc4-d0b1-e911-a824-000d3a43d70a'%20or%20primarycontactid%2Fcontactid%20eq%20'aa33e96f-a551-ea11-a812-000d3a2bc66a'%20or%20primarycontactid%2Fcontactid%20eq%20'c9680caf-9a51-ea11-a812-000d3a2bc66a'

{
    "@odata.context": "https://noi.crm4.dynamics.com/api/data/v9.2/$metadata#accounts(name,primarycontactid)",
    "@Microsoft.Dynamics.CRM.totalrecordcount": -1,
    "@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
    "value": [
        {
            "@odata.etag": "W/\"61617658\"",
            "name": "Weico GmbH",
            "accountid": "55c10558-a551-ea11-a812-000d3a2bc66a"
        },
        {
            "@odata.etag": "W/\"195991599\"",
            "name": "Torggler Chimica AG",
            "accountid": "acb14d2b-dbb1-e911-a823-000d3a3a6da8"
        },
        {
            "@odata.etag": "W/\"202486910\"",
            "name": "NOI Labs - Free Software Lab",
            "accountid": "b3a678f9-2c93-ec11-b400-000d3a4ca66d"
        }
    ]
}

I've tested it with three accountids but this solution should work if first the contacts are queried and then all accountids returned by contacts get "ORed" together to a big query.

sseppi commented 2 years ago

@toburger I think there has been a misunderstanding. We need two different and indipendent calls to get:

  1. All accounts that has been tagged as NOI Community;
  2. All contacts that has been singularly tagged as NOI Community. Not always a NOI Community contact isassociated to a NOI Community Account and vice versa not all accounts associated to a NOI Community Account has to be shown in the App.

For this reason we need to find a solution to identify the best filtering mode.

toburger commented 2 years ago

Gotcha, then we need a field on the accounts in order to filter them by NOI community membership. At the moment I am querying the referenced contact on the accounts an from there I am filtering by the NOI community field.

sseppi commented 2 years ago

Looking at the JSON you shared I think that the information should be stored in on of the following two fields: new_accountcat_brandplace or crb14_accountcat_placepresscommunity

toburger commented 2 years ago

Ah perfect! crb14_accountcat_placepresscommunity is the field which is of interest for us.

image

The following query now returns the name, website, email and address info of the top 10 (active) accounts which contain the id "952210000" in the field crb14_accountcat_placepresscommunity.

{
    "@odata.context": "https://noitest.crm4.dynamics.com/api/data/v9.2/$metadata#accounts(name,noi_nameit,websiteurl,emailaddress1,address1_line1,address1_city,address1_postalcode)",
    "value": [
        {
            "@odata.etag": "W/\"70373827\"",
            "name": "Loacker AG",
            "noi_nameit": "Loacker Spa",
            "websiteurl": "http://www.loacker.com",
            "emailaddress1": "info@loacker.com",
            "address1_line1": "Gastererweg 3",
            "address1_city": "Unterinn-Ritten",
            "address1_postalcode": "39054",
            "accountid": "bf00c31a-10a3-e911-a821-000d3a289705",
            "address1_composite": "Gastererweg 3\r\nUnterinn-Ritten 39054"
        },
        {
            "@odata.etag": "W/\"70373844\"",
            "name": "Biologik Systems",
            "noi_nameit": "Biologik Systems",
            "websiteurl": null,
            "emailaddress1": "info@bioboilersys.com",
            "address1_line1": "Via Volta 13/A",
            "address1_city": "Bolzano",
            "address1_postalcode": "39100",
            "accountid": "d0b1b92e-b3af-e911-a827-000d3a289705",
            "address1_composite": "Via Volta 13/A\r\nBolzano 39100"
        },
        {
            "@odata.etag": "W/\"70373873\"",
            "name": "NOI AG",
            "noi_nameit": "NOI Spa",
            "websiteurl": "https://noi.bz.it",
            "emailaddress1": "info@noi.bz.it",
            "address1_line1": "A.-Voltastr. 13A",
            "address1_city": "Bozen",
            "address1_postalcode": "39100",
            "accountid": "dc653ca5-a6ba-e911-a826-000d3a43d098",
            "address1_composite": "A.-Voltastr. 13A\r\nBozen 39100"
        }
    ]
}
toburger commented 2 years ago

To summarize everything the following queries are of interest:

Contacts

https://api.community.noi.testingmachine.eu/contacts?%24filter=Microsoft.Dynamics.CRM.ContainValues(PropertyName%3D%40p1,PropertyValues%3D%40p2)%20and%20statuscode%20eq%201&%40p1='noi_contactcat_placepresscommunity'&%40p2=%5B'181640000'%5D&%24top=100&%24select=emailaddress1,firstname,lastname

{
    "@odata.context": "https://noitest.crm4.dynamics.com/api/data/v9.2/$metadata#contacts(emailaddress1,firstname,lastname)",
    "value": [
        {
            "@odata.etag": "W/\"70373788\"",
            "emailaddress1": "agloacker@loacker.com",
            "firstname": "Andreas",
            "lastname": "Loacker",
            "contactid": "1df5574d-8bbe-e911-a825-000d3a43de3c"
        },
        {
            "@odata.etag": "W/\"70373715\"",
            "emailaddress1": "i.cainelli@noi.bz.it",
            "firstname": "Ilaria",
            "lastname": "Cainelli",
            "contactid": "576895ce-f805-ea11-a811-000d3a4aa4e2"
        },
        {
            "@odata.etag": "W/\"70373739\"",
            "emailaddress1": "a.demez@noi.bz.it",
            "firstname": "Alexia",
            "lastname": "Demez",
            "contactid": "761a6ef2-f805-ea11-a811-000d3a4aa4e2"
        },
        {
            "@odata.etag": "W/\"70373674\"",
            "emailaddress1": "m.egger@noi.bz.it",
            "firstname": "Marion",
            "lastname": "Egger",
            "contactid": "7a5d9b3a-f905-ea11-a811-000d3a4aa4e2"
        },
        {
            "@odata.etag": "W/\"70373695\"",
            "emailaddress1": "l.geier@noi.bz.it",
            "firstname": "Lisa",
            "lastname": "Geier",
            "contactid": "7f3ebb76-7a6f-ea11-a811-000d3a4aa602"
        },
        {
            "@odata.etag": "W/\"70373602\"",
            "emailaddress1": "aaron.estrada@eurac.edu",
            "firstname": "Aaron Ruben",
            "lastname": "Estrada Poggio",
            "contactid": "253fbb76-7a6f-ea11-a811-000d3a4aa602"
        },
        {
            "@odata.etag": "W/\"70373763\"",
            "emailaddress1": "diana.t@biologik.it",
            "firstname": "Tobias",
            "lastname": "Diana",
            "contactid": "f540bb76-7a6f-ea11-a811-000d3a4aa602"
        }
    ]
}

Accounts

https://api.community.noi.testingmachine.eu/accounts?%24top=10&%24filter=Microsoft.Dynamics.CRM.ContainValues(PropertyName%3D%40p1,PropertyValues%3D%40p2)%20and%20statuscode%20eq%201&%40p1='crb14_accountcat_placepresscommunity'&%40p2=%5B'952210000'%5D&%24select=name,noi_nameit,websiteurl,emailaddress1,address1_line1,address1_city,address1_postalcode

{
    "@odata.context": "https://noitest.crm4.dynamics.com/api/data/v9.2/$metadata#accounts(name,noi_nameit,websiteurl,emailaddress1,address1_line1,address1_city,address1_postalcode)",
    "value": [
        {
            "@odata.etag": "W/\"70373827\"",
            "name": "Loacker AG",
            "noi_nameit": "Loacker Spa",
            "websiteurl": "http://www.loacker.com",
            "emailaddress1": "info@loacker.com",
            "address1_line1": "Gastererweg 3",
            "address1_city": "Unterinn-Ritten",
            "address1_postalcode": "39054",
            "accountid": "bf00c31a-10a3-e911-a821-000d3a289705",
            "address1_composite": "Gastererweg 3\r\nUnterinn-Ritten 39054"
        },
        {
            "@odata.etag": "W/\"70373844\"",
            "name": "Biologik Systems",
            "noi_nameit": "Biologik Systems",
            "websiteurl": null,
            "emailaddress1": "info@bioboilersys.com",
            "address1_line1": "Via Volta 13/A",
            "address1_city": "Bolzano",
            "address1_postalcode": "39100",
            "accountid": "d0b1b92e-b3af-e911-a827-000d3a289705",
            "address1_composite": "Via Volta 13/A\r\nBolzano 39100"
        },
        {
            "@odata.etag": "W/\"70373873\"",
            "name": "NOI AG",
            "noi_nameit": "NOI Spa",
            "websiteurl": "https://noi.bz.it",
            "emailaddress1": "info@noi.bz.it",
            "address1_line1": "A.-Voltastr. 13A",
            "address1_city": "Bozen",
            "address1_postalcode": "39100",
            "accountid": "dc653ca5-a6ba-e911-a826-000d3a43d098",
            "address1_composite": "A.-Voltastr. 13A\r\nBozen 39100"
        }
    ]
}

I've included the statuscode field in the filter to only retrieve active accounts and contacts...

sseppi commented 2 years ago

Finally I think we got it!

Can you please finalize everything, write the readme file with the information about:

Thanks

toburger commented 2 years ago

I'll do that! 👍

toburger commented 2 years ago

I've made a pull request: noi-techpark/it.bz.noi.community-api#18

RudiThoeni commented 2 years ago

all online