topic Re: Errors Posting Equipment Entries with to many Custom Field in BIM 360 API Forum

Errors Posting Equipment Entries with to many Custom Field

Anonymous — Tue, 11 Apr 2017 23:09:21 GMT

I am using python and the request module to post upserts to the equipment table. For the most part everything seems to be working with some notable exceptions.

1. I have about 80 custom fields that I am posting to the entry. When I try to pass all the custom fields I get <Response [400]> errors. When I trim the array of custom fields to ANY 33 custom fields everything posts properly. When I extend beyond a certain buffer (33) I am met with the <Response [400]> error and "No JSON object could be decoded" from pythons request module. Does the post have a buffer I am exceding?

2. I have a mix bag of text, numeric, checkbox custom fields predefined in my equipment table. It seems that only text fields are being set by upserts to the equipment table. Thoughts?

Attached is a printout for one of the posts. The printout includes the first 34 custom fields. When I reduce the custom field array to 33 entries and or pick any other 33 entries in my array of 80 fields my post work properly.

{'created_by': 'YYYYYYY@YYYYYY.COM',
'custom_field_values': [{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'862aa0dc-2fb4-47ef-b585-71745a0abcb6',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'e2bbb106-73cb-421e-b136-9b415f427bc6',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'2abd0985-6c9a-49ce-b2bc-59a1050a298e',
'value': 10},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'fe5e87f9-6f1a-4bd2-9058-fa263b2ac071',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'cb3e62d1-2621-4309-bb04-7a66b4378ec9',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'ee26da16-c5e5-4c10-a924-22799f7391ee',
'value': 'Input_01'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'77606ac9-3532-4c7d-894e-7b7235315bf5',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'5f1460ae-c493-4851-9331-266bcbb257bb',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'fc49f100-16de-4892-9213-74f1fe9ef621',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'1ff8e6bd-0542-4766-b1d5-54a12a65c55b',
'value': None},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'd7ea9817-a29f-45eb-a218-13cd3b0a0b27',
'value': 1.0},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'68222ffa-1ff8-4993-a615-74375fc9f29a',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'd138a6fe-5d57-4137-9c47-a5087d60bcb9',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'99241012-06e9-465e-b5af-c1608409ba6c',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'f948be07-fb81-457a-8c9c-a4e12cdb2030',
'value': None},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'a6dce1f8-1e40-4c14-a331-663b7da0e332',
'value': 1},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'81e993c7-a577-4853-97f5-f948182f441e',
'value': 1},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'2fb8884c-4a38-48be-ba96-c1fabec5b253',
'value': None},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'409e9e27-709d-4c5a-905d-c4ca61e290a8',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'5a586d74-e039-42a2-8280-cb15d10acad2',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'1e359c8e-7c0b-47b1-9537-40fe72bd6c26',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'a518c65d-a537-46fe-9f94-e997dc078842',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'5f3f82b8-6a95-4ebe-9216-17c869bc1008',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'c0bb7aef-5017-46fa-bcdd-6a30e48dec13',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'6a77454c-27ef-4e57-96f9-a23a84fea37c',
'value': 1.0},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'e1224ee0-e7c3-4998-a3f0-0312e6aea7fb',
'value': 1.0},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'55e2b3bf-c01d-43e0-b167-9dc2a24e9906',
'value': 1.0},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'553fdd4a-a796-4a3a-94a1-5de32df8beb2',
'value': 1},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'e7c0138b-44ce-4ecf-abbd-ad93ce29fe78',
'value': None},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'8bbd0e86-5d89-47cd-84f7-eb4c805f549b',
'value': 'a'},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'bfd1e275-53cf-48ef-ad0c-2fcce79d2a23',
'value': None},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'3bfb6d18-b2d8-49b8-ad5f-3e42f509dcec',
'value': True},
{'container_id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'container_type': 'Equipment',
'custom_field_definition_id': u'f7c4fe31-fa90-426d-82e0-d5141a1572fd',
'value': 'a'}],
'description': 'Pushed Item 1',
'id': u'5a74e520-2943-4a3a-9cb3-2f96e5a230ac',
'name': 'Input_01',
'uri_references': [{'caption': 'yahoo',
'name': 'yahoo',
'path': 'https://www.yahoo.com'}]}

Re: Errors Posting Equipment Entries with to many Custom Field

mikako_harada — Wed, 12 Apr 2017 20:01:39 GMT

Hi Michael,

Looks like you are using Field API

POST /api/equipment

https://bim360field.autodesk.com/apidoc/index.html#mobile_api_method_32

your code below is not a valid JSON.

I used a tool like:

http://jsonviewer.stack.hu/

Also,

>>>>

Each custom field value has the following fields:

id : The 36 byte GUID of the custom field value.
custom_field_definition_id : The 36 byte GUID of the parent custom field definition.
container_id : In this case, it points to the piece of equipment that it's associated with, so it would be the equipment's 36 byte GUID.
container_type : In this case, it would be 'Equipment'.
value : The value of the custom field.

<<<<

I don't seem to see "id" in your string.

Could you try reviewing with these points in mind?

Re: Errors Posting Equipment Entries with to many Custom Field

Anonymous — Wed, 12 Apr 2017 20:17:08 GMT

This is true, I am not sending the id field, but the JSON does appear to be valid when I reduce the size of the custom field payload to 32 fields it post properly to field and I see the values in field.

Re: Errors Posting Equipment Entries with to many Custom Field

mikako_harada — Wed, 12 Apr 2017 20:23:43 GMT

Did you try the online json viewer I pointed with the string you pasted? When I tried it, it says invalid. Perhaps, you can attach the string in a txt file to this post? Maybe copy and paste is adding something which makes the strong invalid.

Re: Errors Posting Equipment Entries with to many Custom Field

Anonymous — Wed, 12 Apr 2017 20:37:43 GMT

Sorry for incompatible copy and paste into my thread. I should have pasted the dict after running json.dumps( myData ). My method is doing this downstream. I just tested via "http://jsonviewer.stack.hu/" and the data I am passing is valid JSON. When I pass 32 fields the data posts to field. When I pass 33 fields I get errors. Attached is a copy of the error prone data that is valid JSON.

{"custom_field_values": [{"custom_field_definition_id": "862aa0dc-2fb4-47ef-b585-71745a0abcb6", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "e2bbb106-73cb-421e-b136-9b415f427bc6", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "2abd0985-6c9a-49ce-b2bc-59a1050a298e", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 10, "container_type": "Equipment"}, {"custom_field_definition_id": "fe5e87f9-6f1a-4bd2-9058-fa263b2ac071", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "cb3e62d1-2621-4309-bb04-7a66b4378ec9", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "ee26da16-c5e5-4c10-a924-22799f7391ee", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "Input_01", "container_type": "Equipment"}, {"custom_field_definition_id": "77606ac9-3532-4c7d-894e-7b7235315bf5", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "5f1460ae-c493-4851-9331-266bcbb257bb", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "fc49f100-16de-4892-9213-74f1fe9ef621", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "1ff8e6bd-0542-4766-b1d5-54a12a65c55b", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": null, "container_type": "Equipment"}, {"custom_field_definition_id": "d7ea9817-a29f-45eb-a218-13cd3b0a0b27", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1.0, "container_type": "Equipment"}, {"custom_field_definition_id": "68222ffa-1ff8-4993-a615-74375fc9f29a", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "d138a6fe-5d57-4137-9c47-a5087d60bcb9", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "99241012-06e9-465e-b5af-c1608409ba6c", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "f948be07-fb81-457a-8c9c-a4e12cdb2030", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": null, "container_type": "Equipment"}, {"custom_field_definition_id": "a6dce1f8-1e40-4c14-a331-663b7da0e332", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1, "container_type": "Equipment"}, {"custom_field_definition_id": "81e993c7-a577-4853-97f5-f948182f441e", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1, "container_type": "Equipment"}, {"custom_field_definition_id": "2fb8884c-4a38-48be-ba96-c1fabec5b253", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": null, "container_type": "Equipment"}, {"custom_field_definition_id": "409e9e27-709d-4c5a-905d-c4ca61e290a8", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "5a586d74-e039-42a2-8280-cb15d10acad2", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "1e359c8e-7c0b-47b1-9537-40fe72bd6c26", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "a518c65d-a537-46fe-9f94-e997dc078842", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "5f3f82b8-6a95-4ebe-9216-17c869bc1008", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "c0bb7aef-5017-46fa-bcdd-6a30e48dec13", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "6a77454c-27ef-4e57-96f9-a23a84fea37c", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1.0, "container_type": "Equipment"}, {"custom_field_definition_id": "e1224ee0-e7c3-4998-a3f0-0312e6aea7fb", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1.0, "container_type": "Equipment"}, {"custom_field_definition_id": "55e2b3bf-c01d-43e0-b167-9dc2a24e9906", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1.0, "container_type": "Equipment"}, {"custom_field_definition_id": "553fdd4a-a796-4a3a-94a1-5de32df8beb2", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1, "container_type": "Equipment"}, {"custom_field_definition_id": "e7c0138b-44ce-4ecf-abbd-ad93ce29fe78", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": null, "container_type": "Equipment"}, {"custom_field_definition_id": "8bbd0e86-5d89-47cd-84f7-eb4c805f549b", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "bfd1e275-53cf-48ef-ad0c-2fcce79d2a23", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": null, "container_type": "Equipment"}, {"custom_field_definition_id": "3bfb6d18-b2d8-49b8-ad5f-3e42f509dcec", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": true, "container_type": "Equipment"}, {"custom_field_definition_id": "f7c4fe31-fa90-426d-82e0-d5141a1572fd", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": "a", "container_type": "Equipment"}, {"custom_field_definition_id": "882b0364-8aeb-4288-b14c-122713cd06b9", "container_id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "value": 1, "container_type": "Equipment"}], "name": "Input_01", "created_by": "me@me.COM", "uri_references": [{"path": "https://www.yahoo.com", "name": "Shotgun", "caption": "Shotgun"}], "id": "5a74e520-2943-4a3a-9cb3-2f96e5a230ac", "description": "Pushed Item 1"}