Magidoc

Using the CoCore API from Microsoft Excel

Yes, you can even use it in a spreadsheet!

Integrating the CoCore API into an Excel spreadsheet using Visual Basic for Applications (VBA) is achievable by leveraging Excel's built-in capabilities to make HTTP requests. Here's a step-by-step guide to assist you:

1. Enable Microsoft XML, v6.0 Reference

Excel's VBA doesn't natively support HTTP requests, so you'll need to enable the Microsoft XML, v6.0 reference:

  • Open Excel and press Alt + F11 to access the Visual Basic for Applications editor.
  • Navigate to Tools > References .
  • In the list, check Microsoft XML, v6.0 .
  • Click OK to confirm.

2. Write the VBA Function

Create a VBA function to send a POST request to the CoCore GraphQL endpoint:

3. Use the Function in Excel

You can now use the FetchJobData function directly in your Excel cells:

  • In a cell, enter: =FetchJobData("job-id") .
  • Replace "job-id" with the actual job ID you wish to query.

The function will return the raw JSON response from the CoCore API.

4. Parse the JSON Response

To extract specific data from the JSON response, you can use a JSON parsing library or write a custom parser. Alternatively, consider using Power Query in Excel, which has built-in support for JSON parsing.

5. Error Handling

Implement error handling to manage potential issues during the HTTP request:

6. Explore API Documentation

For detailed information on available queries, mutations, and schema definitions, refer to the CoCore API documentation at https://docs.wearecococo.com .

By following these steps, you can integrate the CoCore API into your Excel spreadsheets using VBA, enabling dynamic data retrieval and manipulation directly within Excel.