I wanted to make an integration with Monday.com which will extract audit logs through API in JSON format file & wanted to place it on SFTP automatically not manually.
Is that possible ?
Wanted to know the best practice also for the same.
I wanted to make an integration with Monday.com which will extract audit logs through API in JSON format file & wanted to place it on SFTP automatically not manually.
Is that possible ?
Wanted to know the best practice also for the same.
Hey @Smiksha,
You can definitely do that by querying the Audit Log API. This is an Enterprise-only feature, though.
You can then save the results of your query wherever you’d like, including your SFTP server. Does that make sense?
-Alex
Hi Alex,
With the help of the article which you shared below, i have tested the API using postman, but when i am putting the values for start & end_date the given values are not working, meaning the data is not fetched between start_date & end_date given rather it is providing all the data.
thanks,
Smiksha
Hi Alex,
With the help of the article which you shared, i have tested the API using postman, but when i am putting the values for start & end_date the given values are not working, meaning the data is not fetched between start_date & end_date given rather it is providing all the data.
Moreover, can you let me know how to extract the file & put on SFTP .
I am a beginner to Monday.com
Thank you for circling back with me!
Would you be able to provide the Audit Log API query you are trying to run? I would love to see the filtering you are attempting to apply. Please avoid sharing your API key though, as it could give access to your account’s API logs.
Here is a StackOverflow with some example code showing how to save JSON output to an FTP server:
No worries, the Audit Log API is quite new as well
-Alex
Hi Alex,
I wouldn’t be able to provide you the Audit Log API as is.
But this is the API am using, in place of my domain,i have added domain.
thanks
Thank you for circling back with me!
In the query string you seem to be using right now, you are not using any date filtering (there don’t seem to be any “from”, or “to” parameters in the query), and you are only asking for 260 events per page. Is that what you are looking to do? It seems like it might make sense to add more parameters to your query if you’d like to retrieve more data per request.
-Alex
Hi ALex,
Can you say on below API:
https://domain.monday.com/audit-api/get-logs?from=2021-07-23T00:00:00Z&to=2021-08-23T00:00:00Z&per_page=260
That API call seems to work for me if I replace the domain with my account, and use my own API key. Is there anything in particular that you’re curious about?
-Alex
My issue is when m using this API, its not fetching data according to From & TO dates provided.
I need to know how can i should check for the issue.
I am using this API with Postman.
The output which i am getting is not in between this timestamp.
I tried with start_date & end_date also but that’s also not working.