https://developer.keap.com/docs/xml-rpc/#data-update-a-record
I am using above link API to update the order related custome field but I don’t know how to udpate data and in which table all the data are stored, how to get record ID and all so it will be greate anyone can guid me over this. Thanks!
Teresa:
You going to want to put together a call that looks like this (quick note – the data table is ‘jobs’, not ‘orders’ – which is a major stumbling block for most. These screenshots are from Make (3rd party like Zapier – but more powerful and less expensive).
<methodCall>
<methodName>DataService.update</methodName>
<params>
<param>
<value><string>ABCD**API-KEY**ABCD</string></value>
</param>
<param>
<value><string>Job</string></value>
</param>
<param>
<value>
<int>ORDER_NUMBER_VALUE</int>
</value>
</param>
<param>
<value>
<struct>
<member>
<name>_TrackingNumber</name>
<value>
<string>TRACKING_NUMBER_VALUE</string>
</value>
</member>
<member>
<name>_ShippingMethod</name>
<value>
<string>SHIPPING_SERVICE_VALUE</string>
</value>
</member>
<member>
<name>_OrderStatus0</name>
<value>
<string>ORDER_STATUS_VALUE</string>
</value>
</member>
<member>
<name>_FulfillmentDate</name>
<value>
<string>FULFILLMENT_DATE_VALUE</string>
</value>
</member>
<member>
<name>_OrderFulfilled</name>
<value>
<string>1</string>
</value>
</member>
<member>
<name>_HoldDate</name>
<value>
<string>HOLD_DATE_VALUE</string>
</value>
</member>
</struct>
</value>
</param>
</params>
</methodCall>
I hope that helps send you in the right direction.
Jeff
1 Like
Great! Thanks a lot, it’s working as I need!
How did you get the details like in which table data is stored and how to structure XML data for API ? It would be greate if you share that details with me!
Thanks alot again!
Here is the best reference for all of that:
https://developer.infusionsoft.com/docs/xml-rpc/
Novak also has some good pointers for the ‘gotchas’:
https://blog.novaksolutions.com/infusionsoft-api-gotchas/
Thanks,
Jeff