Script to read CSV file and update CRM using ZenDesk API
$30-35 USD
Selesai
Dibuat lebih dari 12 tahun yang lalu
$30-35 USD
Dibayar ketika dikirim
I require a script that will be run manually, it will read a CSV file which contains users external-id's. Using the external-id's it will lookup users indivudally in our CRM to find their internal-id.
Once you get the internal-id, it used to update the user's profile.
## Deliverables
I require a script that will be run manually,
it will read a CSV file consisting of some ID #'s
110000,10001, 11002, 11003 etc.
it will then query our CRM
.[login to view URL]
Which then returns the following XML:
<records type="array" count="1">
<record>
<created-at type="datetime">2011-06-22T09:25:02-07:00</created-at>
<details/>
<external-id>1017069563</external-id>
<id type="integer">65767968</id>
<is-active type="boolean">true</is-active>
<last-login type="datetime">2012-01-25T14:04:12-08:00</last-login>
<locale-id type="integer">1</locale-id>
<name></name>
<notes></notes>
<openid-url nil="true"/>
<organization-id type="integer">20479158</organization-id>
<phone/>
<restriction-id type="integer">4</restriction-id>
<roles type="integer"></roles>
<time-zone>Tijuana</time-zone>
<updated-at type="datetime">2012-01-25T14:04:25-08:00</updated-at>
<current-tags/>
<email>carlos@[login to view URL]</email>
<is-verified type="boolean">true</is-verified>
<photo-url>
http://.[login to view URL]
</photo-url>
<uses-12-hour-clock type="boolean">true</uses-12-hour-clock>
<custom-role-id nil="true"/>
<groups type="array"/>
</record>
</records>
It should then grab this element:
<id type="integer">65767968</id>
Then uses the ZenDesk API's PUT to update the following field:
<organization-id type="integer">20479158</organization-id>
<[login to view URL]>