Trying to figure out how to create a new meter reading through the API.
I gather this needs to be done through item_installed and meter_reading_xref.
My first attempt was to use bo_search_keys to specify the meter_id, but this ends up finding and updating the last meter reading, which is undesirable. This makes sense in hindsight.
Attempt 1:
<root>
<session email="" alias="">
<state bc_name="item_installed">
<action name="data">
<main>
<row>
<item_id>556867</item_id>
</row>
</main>
<meter_reading_xref use_retrieve_limit="true">
<row>
<curr_reading>18</curr_reading>
<bo_search_keys>
<item>
<name>item_id</name>
<value>556867</value>
</item>
<item>
<name>meter_id</name>
<value>1</value>
</item>
</bo_search_keys>
</row>
<row>
<curr_reading>19</curr_reading>
<bo_search_keys>
<item>
<name>item_id</name>
<value>556867</value>
</item>
<item>
<name>meter_id</name>
<value>2</value>
</item>
</bo_search_keys>
</row>
</meter_reading_xref>
</action>
</state>
</session>
</root>Attempt 2 was to just specify the meter readings as rows without search keys.
<root>
<session email="" alias="">
<state bc_name="item_installed">
<action name="data">
<main>
<row>
<item_id>556867</item_id>
</row>
</main>
<meter_reading_xref use_retrieve_limit="true">
<row>
<curr_reading>18</curr_reading>
<meter_id>1</meter_id>
</row>
<row>
<curr_reading>19</curr_reading>
<meter_id>2</meter_id>
</row>
</meter_reading_xref>
</action>
</state>
</session>
</root>Weirdly, this fails, but if I specify readings that already match an existing reading, it fails because “A row with the identical values for Reading, Reading Date,Source, Replacement and Credit data already exists for the 'JobInvoicingTest_STD' item and 'Total B&W' Meter Type.”
If I update the curr_reading to not be the same as an existing value, then I just get:
succeeded:false
Error Message:: Execute Macro 'Save' failed.
reason: <root><BOName></BOName><MessageID></MessageID><MessageAsteaCode>A2GEN017</MessageAsteaCode><ElementName></ElementName><Message>System error occurred. Contact your System or Database Administrator.
Date: 2024-06-10 9:21:37 PM
Event: 65535
Ref #: b590b1eb-8845-45ec-8819-b00d88ebce30
Date: 2024-06-10 11:21:37 AM UTC</Message><Row></Row><Code>AsteaException</Code></root>
I suspect I’m close, but I need some help. I want to be able to submit meter readings from an external application. These should be able to be submitted with a reference ideally, like the order id for meters logged through a service order, and a new reading should be created even if the value is the same as an existing reading.
