Need help with REST API for BusinessWorkspace Creation in CS22.3

wang yueting

Hi All, I have created xECM with dummy info of business application because there is no real business use cases of xECM integration with SAP or SFSF. However, I do need to create Business workspaces using REST API via early workspace creation. As my workspace is dependent on category info to decide sublocation, therefore I have followed OpenText REST API swagger guide and created json file like

   uploaddata = {       'template_id': 57339,        'parent_id' : 56458,       'name': 'S7788435-Tangshang',        'ext_system_id': 'Dummy1',       'bo_type': 'saptt3',       'bo_type_id': 3,       'bo_type_name': 'Candidate BO',       'roles':{"categories":{"49555":{"49555_2":"Ding San","49555_3":"S657890","49555_7":"Male"}}}          }   However, system prompts error with message {"error":"Missing required template. "}

Inspecting all data fields values. I am sure that they are correct. I have also followed up some other guy who used below JSON file and claimed successful in CS 21.4.

    uploaddata = {       'template_id': 57339,         'parent_id' : 56458,       'name': 'S7788435-Tangshang',        'description': 'are you joking?'         }

Bad luck it also does not work and same error message. In the end I use SmartUI to manually create business workspace. By tracing network I captured the json content. with minor change to some textfield, although system allows such BW creation. Content look like:

    uploaddata = {"template_id":57339,"name":"Workspace name is generated automatically.","type":848,                  "parent_id":56458,"bo_type":"saptt3","bo_type_id":3,"bo_type_name":"Candidte BO","description":"",                  "ext_system_id":"Dummy1","ext_system_name":"SAP1","external_identity":"","external_identity_type":"",                  "external_source":"","ibo_workspace_id":0,"image_url":"","order_new":-1,"reference_type":"4",                  "mime_type":"Business Workspace","size":"","itemId":"","roles":{"categories":{"49555":{"49555_2":"JiangJing",                "49555_3":"S333223","49555_7":"Male","49555_5":"","49555_6":"","49555_1":{"upgradeable":"","version_number":4}}}},                "source_parent_id":56458}

Yet by testing in program, i still face same error "{"error":"Missing required template. "}" By inspecting the json content and API guide, I dun think there is any template info missing. Can anyone share with some experience?

wang yueting

The problem is solved by myself. There are actually a few tricks that might help you guys.

1. Request header should be headers = {'OTCSTicket': get_ticket(), 'Content-Type': 'application/x-www-form-urlencoded'} instead of content type as 'application/json' format. This also causes confusion when using smart UI to simulate because browser developer indicates as application/multipart.
2. Use " instead of ' for json file.
3. You need to pass in data as "body" = <stringfied json> instead of body : { json format content }. OpenText business workspace API guide also did not specify it clearly although it did mention that you need to pass using "body" =. Unlike other applications that supports json file directly. You must remember to convert to json file's string format and pass as body value.

jsonstring = json.dumps(uploaddata)
data = {'body': jsonstring}

With all these three issues solved, I am able to create BW by python code

successfully.