Automating CRUD operations in MS Places
Hi, Has anyone been able to automate CRUD operations in MS Places yet? Given that the Places API calls support user access tokens only currently and Application access tokens isn't yet supported? We were able to do Get operations using App tokens but when run anything to modify, For Ex: Create a building using Set-Placev3 cmdlet it gives error. When raised an MS ticket they confirmed that the calls doesn't support application tokens yet.. We have a showstopper kind of situation.Unable to get Primary Keys in the tables
I am not able to get primary key in EmailDelivered , EmailOpened , EmailSent , FormSubmitted , FormVisited , WebsiteVisited . Below is the reference of one of the Table nad other tables are also present in this : https://learn.microsoft.com/en-us/common-data-model/schema/core/applicationcommon/foundationcommon/crmcommon/solutions/customerinsightsjourneys/emaildelivered Could you please help me in finding primary key in these tables. Have you ever faced this issue? what should you suggest in this case.
Extracting attachments from Business Central via API early 2024
Hi all According to the API documentation, the pdf or images attached to e.g. purchase invoices can be found using /attachments endpoint. This works very well for late 2024 and 2025 invoices, but finance says an update was applied mid 2024 and all invoices before july 2024, do not have any attachments. Also, instead of using the /puchaseInvoices endpoint, the early entries can instead be found under /generalLedgerEntries. I have tried, what seems to be, all options, but finance can show the PDF for a posting in the system, but for some reason, it seems impossible for me to find it using the API. In conclusion, the data (PDFs) exist, they can be found using the system but I do not know where to look when using the API. Do anyone have a recommendation on how to proceed or solve the issue? Thanks in advance! Best, Victor
How to filter JSON data to a specific result?
Hi all, I am trying to get JSON data from the IEX API and have used the WEBSERVICE() function, but I can't seem to filter it down to the values I need. For example: If I want the "total cash" for the first year financials of Apple; I have tried this formula: =VALUE(WEBSERVICE("https://api.iextrading.com/1.0/stock/AAPL/financials?period=annual/0/totalcash")) Which gives an error. I think the incorrect part is the "/0/" but I don't see how to specify which year I want. Any help is really appreciated. Thanks,
Is Warehouse management APIs are available in business central?
Hi Team, I have use case like to enter goods item level and need to store it in business central.Like i need to do like to create purchase order from invoice document and do inventory put Away through API .Create PO API is there.Please guide me to get inventory put-away API? Thanks, ArdraSharepoint Sync-On-Demand & Application.Path
A few years back I traced some weird VBA Macro code behavior in Excel back to a SharePoint feature called "Sync-On-Demand". When Sync-On-Demand is turned on, the VBA code "Application.Path" no longer returns the actual file location, and starts returning a SharePoint site. It does these without any warning and as far as I can tell there is no documentation about this. This broke my companies primary management software until I traced it down and turned off Sync-On-Demand for my remote users. As of this week, the Sync-On-Demand option is not only gone from the Settings, but it seems to be secretly turned back on in the background as well. If we weren't inspecting values after the code crashed, we would not even know this is happening. This means that right now anyone who is using SharePoint and thinks they are opening a local file, is actually opening a web location without even being told about it in any visible way. And it's being done through some sort of background hackery. It's shady as F. We have opened a support ticket but so far they don't even seem to know they have done this and are pointing to new settings locations, but those do not yet exist for us. Is there anyone here with knowledge of this issue and some way for us to turn the sneaky Sync-On-Demand off as of today? The new help docs provided to us show a Conext Menu option available from an Explorer window, but that option does not exist for us. Does anyone know a way to get the file location of whatever Excel file is running a VBA Macros? Application.Path is supposed to be that, but I need a new way that actually works to return the actual harddrive path location, not the SharePoint location.
Office 365 API - Subscription
Hi, We have been using the Office 365 API to send events to our SIEM for a number of months. Since Monday we have received the following error: AF20023","message":"The subscription was disabled I've looked at "https://learn.microsoft.com/en-us/office/office-365-management-api/troubleshooting-the-office-365-management-activity-api#enable-unified-audit-logging-in-office-365" but even if I try and start a subscription, it will still return that it is disabled? Not entirely sure what else I can check.Which APIs are the best for my outlook software
Hey community, I want to build a software that would automatically process incoming emails (using an LLM) from an outlook inbox and perform tasks, like forwarding the email to another inbox, or enriching the email body text with data from a CRM. The software should be easy to integrate into new organisations, so I was looking at building an outlook extensions.But i could not find any triggers that would work on any incoming email. I've looked at the Microsoft documentation for autolaunch add-ins: https://learn.microsoft.com/en-us/office/dev/add-ins/outlook/autolaunch But I have seen that I could create a email subscription with the microsoft REST API https://learn.microsoft.com/en-us/graph/api/subscription-post-subscriptions?view=graph-rest-1.0&tabs=http#request I also discovered this blog post that revolved around a similar problem https://techcommunity.microsoft.com/discussions/microsoft-365/trigger-api-from-received-email/3906340 The suggested solution includes using microsoft power automate, but I would like my solution to work without any additional subscriptions. So my question is, what are the best API's to develop my software. It should be easy to install it on every machine of employees of a client company (like installing the outlook add-on) and analyse the content of the email automatically to then perform some actions, like adding text to the body of an email. Thanks for any advice in advance :)
'$skiptoken' limit error for Microsoft Exchange online Reporting web service API
I was working on integrating MessageTrace report API as a part of my SIEM integration: https://reports.office365.com/ecp/reportingwebservice/reporting.svc/MessageTrace[?ODATA%20options] I have noticed that, whenever my $skiptoken reaches the limit 999999 , it throws the following error with 500 status code: { "odata.error": { "code": "UnknownError", "message": { "lang": "", "value": "An error has occurred on the server." } } } It was working fine for the 999998 value, but wasn't for the $skiptoken value 999999. Is there any limitations on $skiptoken value from the API itself? Also, need information, if $skiptoken value 999999 exists, for example, "odata.nextLink": "../../reportingwebservice/reporting.svc/MessageTrace?$filter=StartDate%20eq%20DateTime'2024-12-02T00%3A00%3A00Z'%20and%20EndDate%20eq%20DateTime'2024-12-02T23%3A59%3A59Z'&$skiptoken=999999" then how can we request the data from next set of events? Can someone let me know, is there any max limit from Microsoft API side or for the $skiptoken?