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, Ardra
Sharepoint 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 options] 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.Data Retention information for Microsoft O365 Message Trace
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] While exploring the API, I found that the API is returning the data from past 10days to the max. Exceeding this, it is giving me server error with 500 response code. Is there is any possible way to obtain the data more than this range, as mentioned that the data retention is 30 days according to: https://learn.microsoft.com/en-us/previous-versions/office/developer/o365-enterprise-developers/jj984335(v=office.15)#data-granularity-persistence-and-availability
