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
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.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?Outlook imap issue
While configuring IMAP, We are getting below errors attached in the screenshots. The PHP INI file has "IMAP" enabled. Our passwords are correct. Error Message: (E_WARNINGJ Authentication failed for user imap_open(): Couldn't open stream {outlook.office365.com/imap/551/nova1idate-cert}Clarification on Rate Limit for Message Trace API Integration
I am currently working on the integration of the Message Trace API and wanted to clarify some details regarding the rate limit. The REST API I am currently using for O365 Message Trace for my integration is: https://reports.office365.com/ecp/reportingwebservice/reporting.svc/MessageTrace[?ODATA options] As mentioned previously, The rate limits for the O365 Message Trace API are generally aligned with the Microsoft Graph API limits: Per-Minute Limit: Up to 60 requests per minute However, during testing the integration, I've noticed that my data is not being ingested within that specified timeframe and not aligning to the specified rate limit. Can someone please confirm if there are any additional limitations or conditions that might cause the rate limit to vary? Are there any other factors, such as throttling or specific request patterns, that could affect the rate limit during data ingestion? Your guidance on this would be greatly appreciated as it would help me optimize the integration process.
