Using an API to Get Sales Orders

monojoker · December 1, 2015, 6:03am

Hi all,

I did a search but can’t find much information on this.

A customer of ours offers their sales order data via an API and I would like to automate the information flow as much as possible.

Absolute perfect scenario is press a button in ERPNext and it Gets all new sales orders for us as vendor and brings them into ERPNext as new Sales Orders with information pre-populated. Now that’s probably only a dream at this point in time. Please tell me if it isn’t

I’m also on the Cloud hosted system so don’t have full control over things and that may limit my options too.

What I had thought of initially was to create an Excel document with custom VBA to fetch the data and format it into columns. Similar to this: http://libkod.info/officexml-CHP-9-SECT-5.shtml That will give me a document I can save as CSV and import using the standard tools.

Given it’s a simple API call to get recent orders:

http://{website}/vendors/api/?request=recent_order&apiKey={myAPIkey}

Is there another or easier way to set this up? Looking for all options so I can weigh up the best one.

Thanks.
Liam.

ccfiel · December 1, 2015, 6:34am

There is a sample code

https://frappe.github.io/frappe/user/guides/app_development/insert-a-document-via-api.html

also

github.com

MPJHorner/ERPNext_PHP_API_Wrapper/blob/master/ERPNext.php

<?php

/**
* ERPNext RESTful API PHP Curl Library
*/

class erpnext{

  public $url;
  public $endpoint;
  public $endpoints-available = array(
                                      'method/login',
                                      'resource/Person',
                                      );
  public $method;
  public $username;
  public $password;

  /**
  * Constructs the class, requires an API url.

This file has been truncated. show original