Skip to main content
Question

Edit XML to CSV loop to HTTP Caller

  • December 18, 2019
  • 3 replies
  • 34 views

Forum|alt.badge.img

I've got a workbench setup that uses a preset xml to Post using HTTP Caller and retrieve an ID, see below:

This works successfully. What I'd like to do is use an external CSV or XLS to loop back around and format the XML Templater with the new data for the next Post.

I can't work out how to do this. I have looked at using XML Updater, but not sure I'm doing it right. Can someone help?

See below of how I've attempted this.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

Forum|alt.badge.img+2
  • 1891 replies
  • December 18, 2019

@kimburrows1242 Just guessing here but I think you need to trigger the XMLTemplater for each update cycle. So if you drop the Creator and instead use a copy of the XLSX input to trigger the XMLTemplater, and then the second copy to update the template that might do it.


Forum|alt.badge.img
  • Author
  • 34 replies
  • December 19, 2019

@kimburrows1242 Just guessing here but I think you need to trigger the XMLTemplater for each update cycle. So if you drop the Creator and instead use a copy of the XLSX input to trigger the XMLTemplater, and then the second copy to update the template that might do it.

Do you mean in the first workbench or the second? If it was going to trigger it, how would the XML Templater know what to change and to loop? I'd be feeding it the correct info, but it would it know what to do with it?


Forum|alt.badge.img+2
  • 1891 replies
  • December 19, 2019

Do you mean in the first workbench or the second? If it was going to trigger it, how would the XML Templater know what to change and to loop? I'd be feeding it the correct info, but it would it know what to do with it?

@kimburrows1242 In your second image. Sheet1 - XMLTemplater & XMLUpdated / Update