Paying $12K for Zapier to Sync Files? Connect Odoo to SharePoint with Graph API

Application (client) ID: 12345678-1234-1234-1234-123456789abc
Directory (tenant) ID:   87654321-4321-4321-4321-cba987654321

Client Secret Value: abc123DEF456ghi789JKL012mno345PQR678

Key: sharepoint.client_id
Value: 12345678-1234-1234-1234-123456789abc

Key: sharepoint.client_secret
Value: abc123DEF456ghi789JKL012mno345PQR678

Key: sharepoint.tenant_id
Value: 87654321-4321-4321-4321-cba987654321

Key: sharepoint.tenant_name
Value: yourcompany

Key: sharepoint.site_name
Value: Sales

Key: sharepoint.drive_name
Value: Documents

from odoo import models, api
import requests

class SharePointConnector(models.Model):
    _name = 'sharepoint.connector'
    _description = 'SharePoint Integration'
    
    def _get_config_param(self, key):
        """Helper to fetch system parameters"""
        return self.env['ir.config_parameter'].sudo().get_param(key)
    
    def get_access_token(self):
        """Authenticate with Microsoft and get access token"""
        client_id = self._get_config_param('sharepoint.client_id')
        client_secret = self._get_config_param('sharepoint.client_secret')
        tenant_id = self._get_config_param('sharepoint.tenant_id')
        
        token_url = f"https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token"
        
        payload = {
            'grant_type': 'client_credentials',
            'client_id': client_id,
            'client_secret': client_secret,
            'scope': 'https://graph.microsoft.com/.default'
        }
        
        response = requests.post(token_url, data=payload)
        
        if response.status_code != 200:
            raise Exception(f"Failed to get token: {response.text}")
        
        return response.json()['access_token']

def get_site_id(self):
    """Get SharePoint site ID"""
    token = self.get_access_token()
    tenant_name = self._get_config_param('sharepoint.tenant_name')
    site_name = self._get_config_param('sharepoint.site_name')
    
    url = f"https://graph.microsoft.com/v1.0/sites/{tenant_name}.sharepoint.com:/sites/{site_name}"
    
    headers = {
        'Authorization': f'Bearer {token}',
        'Accept': 'application/json'
    }
    
    response = requests.get(url, headers=headers)
    
    if response.status_code != 200:
        raise Exception(f"Failed to get site: {response.text}")
    
    return response.json()['id']

def get_drive_id(self, site_id):
    """Get document library (drive) ID"""
    token = self.get_access_token()
    drive_name = self._get_config_param('sharepoint.drive_name')
    
    url = f"https://graph.microsoft.com/v1.0/sites/{site_id}/drives"
    
    headers = {
        'Authorization': f'Bearer {token}',
        'Accept': 'application/json'
    }
    
    response = requests.get(url, headers=headers)
    
    if response.status_code != 200:
        raise Exception(f"Failed to get drives: {response.text}")
    
    # Find drive by name
    drives = response.json()['value']
    for drive in drives:
        if drive['name'] == drive_name:
            return drive['id']
    
    raise Exception(f"Drive '{drive_name}' not found")

def upload_file(self, file_content, file_name, folder_path=''):
    """
    Upload file to SharePoint
    
    :param file_content: Binary file content
    :param file_name: Name of file (e.g., 'contract.pdf')
    :param folder_path: Path in SharePoint (e.g., 'Contracts/2025')
    """
    token = self.get_access_token()
    site_id = self.get_site_id()
    drive_id = self.get_drive_id(site_id)
    
    # Construct upload URL
    if folder_path:
        url = f"https://graph.microsoft.com/v1.0/sites/{site_id}/drives/{drive_id}/root:/{folder_path}/{file_name}:/content"
    else:
        url = f"https://graph.microsoft.com/v1.0/sites/{site_id}/drives/{drive_id}/root:/{file_name}:/content"
    
    headers = {
        'Authorization': f'Bearer {token}',
        'Content-Type': 'application/octet-stream'
    }
    
    response = requests.put(url, headers=headers, data=file_content)
    
    if response.status_code not in [200, 201]:
        raise Exception(f"Upload failed: {response.text}")
    
    return response.json()

from odoo import models

class SaleOrder(models.Model):
    _inherit = 'sale.order'
    
    def action_confirm(self):
        """Override confirm to upload contract"""
        res = super().action_confirm()
        
        # Generate PDF report
        pdf_content = self.env.ref('sale.action_report_saleorder')._render_qweb_pdf([self.id])[0]
        
        # Upload to SharePoint
        connector = self.env['sharepoint.connector'].create({})
        file_name = f"SO{self.name.replace('/', '_')}.pdf"
        folder_path = f"Sales/Contracts/{self.date_order.year}"
        
        try:
            result = connector.upload_file(
                file_content=pdf_content,
                file_name=file_name,
                folder_path=folder_path
            )
            self.message_post(
                body=f"Contract uploaded to SharePoint: {result['webUrl']}"
            )
        except Exception as e:
            self.message_post(
                body=f"SharePoint upload failed: {str(e)}"
            )
        
        return res

def list_files(self, folder_path=''):
    """List files in SharePoint folder"""
    token = self.get_access_token()
    site_id = self.get_site_id()
    drive_id = self.get_drive_id(site_id)
    
    if folder_path:
        url = f"https://graph.microsoft.com/v1.0/sites/{site_id}/drives/{drive_id}/root:/{folder_path}:/children"
    else:
        url = f"https://graph.microsoft.com/v1.0/sites/{site_id}/drives/{drive_id}/root/children"
    
    headers = {
        'Authorization': f'Bearer {token}',
        'Accept': 'application/json'
    }
    
    response = requests.get(url, headers=headers)
    
    if response.status_code != 200:
        raise Exception(f"Failed to list files: {response.text}")
    
    return response.json()['value']